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?
<tbody>
</tbody>
Account | City | Color | Response |
1202 | Boston | Y | |
1203 | Red | ||
1204 | NY | Blue | N |
Dallas | Green | ||
1206 | Purple | Y | |
LA | Y | ||
1208 | N |
<tbody>
</tbody>