Formula Countif
Hi TRM,
assuming you have your data betwwen a2 and b1000
on d2 use =sumproduct(--(a2:a1000=c2)*(b2:b1000="premium")
on e2 use =sumproduct(--(a2:a1000=c2)*(b2:b1000="scheduled")
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"TRM" escreveu:
I have two columns - one with company names in and the other with the word
"premium" or "scheduled". I'm looking for the formula to count the company
name (in one column) and if it is a scheduled or premium service (in another
column) so that I will end up with a count that ABC company used scheduled
service 200 times this month and premium 300. Any assistance greatly
appreciated.
TRM
|