Hi All,

I tried digging for this info and tried to use the "CountifS" to perform this but for some reason, its not working.

Here's the formula:

=COUNTIFS(NoCom_Meter_info!C:C,"IN",NoCom_Meter_info!N2:N2000,"901.0375")

I'm getting#Value error when I do this formula. Any idea why this is? When i separate this into two cells, the formula works but need to know how many "IN" have the # "901.0375".

Thoughts on what I'm doing wrong?

thanks!