Multiple CountIfs

[sammipd]

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?
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]Account[/TD]
[TD]City[/TD]
[TD]Color[/TD]
[TD]Response[/TD]
[/TR]
[TR]
[TD]1202[/TD]
[TD]Boston[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]1203[/TD]
[TD][/TD]
[TD]Red[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1204[/TD]
[TD]NY[/TD]
[TD]Blue[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Dallas[/TD]
[TD]Green[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1206[/TD]
[TD][/TD]
[TD]Purple[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]LA[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]1208[/TD]
[TD][/TD]
[TD][/TD]
[TD]N[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Assuming your example is in range A1:D8, you can do something like this:

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

 

[Fluff]

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

 

[sammipd]

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

 

[Fluff]

Glad we could help & thanks for the feedback