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))

--
Biff
Microsoft Excel MVP


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