Please help. I'm trying to count values or non blank cells across multiple columns and am using the COUNTIFS function
I am trying to count non blank cells across multiple columns for different industry codes. Please see attached. I am trying to count for industry code 1 how many call 1, call 2, call 3 etc. occurred and then repeat for industry code 2, 3 etc.
I have tried lots of variations of the COUNTIFS function but here is one that I thought should work:
=COUNTIFS(A2:A30,1,C2:G30,"<>")
I am using Excel 2010.
Regards
Paul
| Attachment | Size |
|---|---|
| sample.xlsx | 31.22 KB |
create pivot table by
create pivot table by Insert->Pivot table
Select the data range or pivot will automatically select it
Press OK
Drop industry column into pivot "Rows" option
Drop one by one call1,call2 etc into " pivot " Values" option
And select "Count of calls"
It will show you the industry wise count of calls by excluding the blanks.
Or
give me email id. I will forward you the sample sheet for your understanding.
Asif