Hi!

Try this:

=SUMPRODUCT(--(B:B100="DR"),--(J1:J100="F"))

Better:

A1 = DR
A2 = F

=SUMPRODUCT(--(B:B100=A1),--(J1:J100=A2))

Biff

"Debi" wrote in message
...
I am atempting to count how many occurances there are when two criteria are
met in the same row but different cells For example in row b there are
initials and in row j there are two different letter f and h. I would
like
the total number of rows that have the initials DR in column b and the
letter
f in column j. Sound simple but I can't seem to get it