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

Done it another way. I was trying to get the total in one go, but I have put
the formula into each row and added them up from that.

"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

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