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.

"Pimamedic" wrote in message
...
=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