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,


"Pimamedic" wrote:

=COUNT(if A1:A6=f,4,0)

Change the range as needed

"bmac" wrote:

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