Formula Countif
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 |
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 |
Formula Countif
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 |
All times are GMT +1. The time now is 05:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com