Afternoon,

I'm using the below formula to count the number of enquires based on the criteria set in the array formula, however it doesn't seem to bring back the correct amount of enquires when i check manually, can anyone point out if there is something wrong with the formula:

=SUM(IF(Status!$J$2:$J$65536="QCKCT",1,0)*IF(Status!$M$2:$M$65536<>"MULSC",1,0)*IF(Status!$F$2:$F$65536="DX",1,0)*IF(Status!$C$2:$C$65536<>"DWS Standard.Bundle",1,0)*IF(Status!$O$2:$O$65536<>"Capita Symonds Limited ZWET",1,0)*IF(Status!$O$2:$O$65536<>"Capita Symonds Ltd incorporating MMB Associates",1,0)*IF(Status!$R$2:$R$65536<>"Severn Trent",1,0)*IF(Status!$R$2:$R$65536<>"Anglian",1,0)*IF(Status!$R$2:$R$65536<>"Southern",1,0)*IF(Status!$R$2:$R$65536<>"Wessex",1,0)*IF(Status!$B$2:$B$65536='Formula Sheet'!J$3,1,0))