=sumproduct(--(B1:B1000="DR"),--(J1:J1000="f"))

"Debi" wrote:

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