Excel countif and
 

is there a "and" condition if you use countif or sumif?
example;


1 c
1
1 c
2
2 < countif(b1:b4,"=c")and(a1:a4,"=1")

Hi!

Try this:

=SUMPRODUCT(--(A1:A4=1),--(B1:B4="C"))

Biff

"KEN" wrote in message
...
is there a "and" condition if you use countif or sumif?
example;


1 c
1
1 c
2
2 < countif(b1:b4,"=c")and(a1:a4,"=1")