formula that reference cells and counts the values in a column but for - Microsoft Community

hello,

i have workbook has several worksheets, named sheet1, sheet2, sheet3, etc.  each sheet belongs customer , each row there employees information, example name, department, date, , payment method.

the payment method description found in column f each worsksheet.

i have sheet name summary,  in column k , l have key. in same worksheet have companies names in column c. extracted companies names sheets , in order.

so in column c cell c2 have first company name extracted sheet1.

column k - k2:k6  -  electronic-pay

descriptions e-pay

t !epay!

t !epay! #mail#

t !epay! m

t !epay! t

t !epay! t#mail#

column l - l2:l5 - mailed out

descriptions mailed

t #mail#

t t

t m

t t#mail#

what need formula key cells (k2:k6)  e-pay are  reference , amount electronically paid in sheet1 column f return in

the summary sheet have column e-pay , column mail. also, formula needs change sheet reference drag down cells.

i hope makes sense , thank in advance

hi joro,

 

 

if you’re trying count number of cells contain data entry e-pay or mailed, can use countif function. here’s link talks how use countif function.

 

if you’re trying total sum of data entered in cells, can either use sum function or sumif function. sum function automatically provide sum of column or rows of numbers. while sumif function sum values in range meets criteria specify.

 

if want create summary of 3 worksheets, might want create pivottable in excel. pivottable can analyze , summarize worksheet data. check link instructions on how use pivottable.

 

let know if need additional details.

Office / Excel / Windows 10 / Office 2016