COUNTIF using conditions

S

Seb

I have a spreadsheet with multiple column.

For example :

Satus Id
Delivered 12
Not delivered 13
Delivered --
Delivered 14

I would to count the number of non-blank cells in the column "Id" depending
on the Status. The goal is to get the number of non-blank cells for Delivered
status and get the number of non-blank cells for Not Delivered status,

In general view I have to count the number of non-blank cells in column Id
depending on the value of the column "status"
 
L

Luke M

=SUMPRODUCT((A2:A100="Delivered")*(NOT(ISBLANK(B2:B100))))

Adjust range as necessary (just make sure they are the same size!)
Note that you can change the "Delivered" to a cell reference if you prefer.
 
T

T. Valko

Try these:

=SUMPRODUCT(--(A2:A100="delivered"),--(B2:B100<>""))

=SUMPRODUCT(--(A2:A100="not delivered"),--(B2:B100<>""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return values from one column IF a certain value in another column 9
Complicated Excel Forumal (to me!) 2
Excel does not accept text format! 0
Counting values in an array where value in one column is not null 5
Count values in array of data where no blanks in one column 4
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Count Blank Cells with Conditions 3
COUNTIF ? 6

Top