Hey Tinkertron
I'd say good morning, but it probably isn't -
COUNTIF will give you info on criteria counts in a range
Code:
=COUNTIF(*range*,"*criteria*")
ie - to find the number of times the word
REVOKE is written in
Sheet1,
Cell range A1:A500:
Code:
=COUNTIF(Sheet1!A1:A500,"REVOKE")
All you need to do is copy the formula and paste it for each of your totals columns and change the criteria!
Is that what you're looking for?