There must be a better way than repeated "countif"...

[jan001]

I'm starting an analysis of workload based on location and nature of the work done. I have 95 separate locations and 28 types of work. What I've started off doing is just apply <strong>=countif</strong> using the range for each specific location as they appear in the results of a search I've already done, and the specific nature of the work. For instance, <strong>=countif(e1825:e1848,"station 20")</strong>, then <strong>=countif(e1849:e1981,"station 21")</strong>, etc.

There must be a faster way...mustn't there? I've begged for VBA training which would probably help but have been told "no" often enough that I've quit asking. Is there a non-VBA way?

This seems so elementary and I keep thinking there must be some command that would parse it out for me, but so far I haven't happened on it, probably because I'm not speaking Excel well enough in my query criteria. Any thoughts?

Will a pivot table do these counts? Would something else?

 

[yangc10]

can you explain a bit of why or what is your purposes of using that formulas?

 

[Roderick_E]

Yes, a pivot table is the answer. Let's suppose the column header in E is "Stations", You will create a pivot table on the source date and COUNT by Stations.

 

[jan001]

The pivot table does appear to have done the trick. Thanks so much!