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