Count if Multiple columns
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
|