One way:

=SUMPRODUCT(--(A1:A1000="RS"),--(H1:H1000="Sent to"), --(J1:J1000=""))

For an explanation, see

http://www.mcgimpsey.com/excel/doubleneg.html


In article ,
"Dean" wrote:

Hi,

I would like to countIf the conditions of multiple columns exist..
CountIf(A:A,"RS" and the respective row in column "H" = "Sent to" but the
same row in column "J" must be blank.)

Help please.
I've spent an hour trying to think how to put this without putting to much
detail and making it to complicated.

Thanks Dean