Forum Discussion
Count data cells with multiple criteria
I'm hoping you kind forum members can help me. I looking for a formula where I can count the number of cells with data included, depending on criteria from two other columns. In my example I wan...
Perhaps
=SUMPRODUCT( (A:A<>"")*(D:D="Joe Bloggs")*(K:K="") )
or
=COUNTIFS( A:A,"<>",D:D,"=Joe Bloggs",K:K,"")
SergeiBaklan that worked a treat, thank you!
DaveWoollven , you are welcome