'COUNTIFS Formula with Multiple Criteria Ranges
Can anyone perhaps help me? I am trying to do the following:
I am trying to make the report pick up if the prospect is "Not Selling" if the "Not Selling" tab was ticked in either the first attempt, the 2nd attempt or the third attempt.
I used the formula below to make it work when there was only 1 attempt but when I try adding an OR function to the formula it gives me an array size error.
=countifs(Database!$R$3:$R,"="&C45+4,Database!$AH$3:$AH,TRUE)
Is there a way of doing something like what I'm trying to do below?
=countifs(OR(Database!$R$3:$R,Database!$X$3:$X,Database!$AD$3:$AD),"="&C45+4,Database!$AH$3:$AH,TRUE)
Thanks in advance
Justin
Solution 1:[1]
Like this possibly, if I have followed what you want:
=OR(Database!$R$3:$R"="&C45+4,Database!$X$3:$X"="&C45+4,Database!$AD$3:$AD"="&C45+4),"="&C45+4
But you may need to sort the detail there.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Solar Mike |