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

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

You can create a helper column that concatenates the company name to the
service type. Sort the data by the helper column and then do subtotal count
on the sorted column.

A B C
1 XYZ Premium =A1&B1
2 ABC Scheduled =A2&B2
3 XYZ Premium =A3&B3

Column C would have the following values:

XYZPremium
ABCScheduled
XYZScheduled

The subtotal would count each of the occurrences for the concatened column

--
Kevin Backmann


"TRM" wrote:

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