[Solved] Count criteria in multiple columns with blanks

[abelt]

I need to get a total when A2:A25 =1 AND E2:E25 is blank. How can I do this?

[FJCC]

The following formula will sum F2:F25 in rows where column A = 1 and column E is blank.

Code: Select all

=SUMPRODUCT(A2:A25=1;ISBLANK(E2:E25);F2:F25)

[abelt]

Thanks, but it didn't work. It should return 1. My first column is either 1, 2, or 3. The second criteria is either text or blank. I need a total if the criteria is both a 1 and blank. In my sample, one row has a 1 in column A, and the cell in column E blank.

[FJCC]

Do you mean that you want a count of the rows that have a 1 in column A and are blank in column E? That would be

Code: Select all

=SUMPRODUCT(A2:A25 = 1; ISBLANK(E2:E25))

[abelt]

Yes! Thank you