Hi,
I'm having a problem with the following formula:
=COUNTIFS(Q1.1!$G$19:$G$1514,K$2,('Stats Sheet'!$G$5:1500,"<>'Stats Sheet'!$B$6"-COUNTBLANK('Stats Sheet'!$G$5:$G$1500),Q1.1!$H$19:$H$1514,$I$2)
I'm after a formula that has 2 conditions as well as if the 3rd condition is A OR B. What i have tried to do above is 2 conditions and everything but C, although it also includes the blank cells.
Any help would be much appreciated.
Bookmarks