Using countif based on values of cells in other columns

  • Thread starter Thread starter bmac
  • Start date Start date
B

bmac

Hello, I would like the count the number of times the number "4" appears in
column D only when the value "F" appears in the same row in column B. I don't
want to sum the 4 values, I just want to count them.

Any help appreciated,

BMAC
 
Try this:

=SUMPRODUCT(--(B1:B10="F"),--(D1:D10=4))

Better to use cells to hold the criteria:

F1 = F
G1 = 4

=SUMPRODUCT(--(B1:B10=F1),--(D1:D10=G1))
 
Sorry, but I don't understand. I have a multi column spreadsheet with other
data not required for the calculation. In column B I have values like N, C,
F, etc. in rows 2-130. In column. In column D I have values like 4, 3, 2, 1,
or 0. I want to be able to count the instances of "4" in column D when there
is an F in column B.

Thanks for your time,
 
Perfect!!!!
Thanks much!

T. Valko said:
Try this:

=SUMPRODUCT(--(B1:B10="F"),--(D1:D10=4))

Better to use cells to hold the criteria:

F1 = F
G1 = 4

=SUMPRODUCT(--(B1:B10=F1),--(D1:D10=G1))
Click to expand...
 
Pinamedic,

How is this post helpful? This isn't a Countif function, nor is it an array
function, nor is it a proper If statement, even one that's out of context.
If your intent was to waste the poster's time, you succeeded. However, if
you want to help people, you should test your formula first before posting
it.

Regards,
Fred.
 
Back
Top