Excel countif and

[KEN]

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")

 

[Biff]

Hi!

Try this:

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

Biff