# Thread: Multiple CountIfs Thanks: 0 Likes: 0

1. ## Multiple CountIfs

I have a large spreadsheet (to ER3500) and need to count specific columns with non-blank cells across the rows. I have tried several CountIf and CountIfs, but I can't get there. A sample spreadsheet is below. I want the total number of rows which have data in the Account, Color, and Response columns. In this example the answer would be 2 (accounts 1204 and 1206). Can you help?
 Account City Color Response 1202 Boston Y 1203 Red 1204 NY Blue N Dallas Green 1206 Purple Y LA Y 1208 N

2. ## Re: Multiple CountIfs

Assuming your example is in range A1:D8, you can do something like this:
Code:
`=SUMPRODUCT(--(A2:A8<>""),--(C2:C8<>""),--(D2:D8<>""))`

3. ## Re: Multiple CountIfs

=COUNTIFS(A2:A8,"<>",C2:C8,"<>",D2:D8,"<>")

4. ## Re: Multiple CountIfs

Thank you Joe4 and Fluff! Both your solutions worked, and saved me a ton of time. Thank you both!

5. ## Re: Multiple CountIfs

Glad we could help & thanks for the feedback