Hi,
I'm using the following to count the records for anything in 815 + CSP/Trunk. But the results I'm getting = FALSE??
=COUNTIF(ONSITEINVT!$A$2:$A$25000,"815")=COUNTIF(ONSITEINVT!$F$2:$F$25000,"CSP/Trunk")
How do I get this to work to give me my count value base on my two conditions?
Thanks
I'm using the following to count the records for anything in 815 + CSP/Trunk. But the results I'm getting = FALSE??
=COUNTIF(ONSITEINVT!$A$2:$A$25000,"815")=COUNTIF(ONSITEINVT!$F$2:$F$25000,"CSP/Trunk")
How do I get this to work to give me my count value base on my two conditions?
Thanks