Forum Discussion
Combining countif with more than one parameter and cells with no value
Hi all, I’m hoping you can help please. I am looking to combine two countif cells into one if possible please? I currently have some data, where the first countif counts the number of values in a col...
That could be
=SUMPRODUCT(--(
((C8:C22>=$C$6)*(C8:C22<=$C$5)+
(E8:E22>=$E$6)*(E8:E22<=$E$5))
>0))for data sets inside values