Home » Forums » Open Source Learning Center » Question and Answer

Please help. I'm trying to count values or non blank cells across multiple columns and am using the COUNTIFS function

Submitted by paulwalsh on 5 September, 2014 - 12:21

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

AttachmentSize
sample.xlsx31.22 KB
‹ Basic Help needed to automate a table when filling in monthly cells. Need dynamic list to populate in another sheet & carry data in destination sheet with it when changed ›
»
akmughal's picture

create pivot table by

Submitted by akmughal on 10 September, 2014 - 01:39.

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

»