Count If Numerous Conditions are TRUE

[gshafiq]

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!

[berlan]

Without seeing the data, try:

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

[gshafiq]

Thanks! That worked! much appreciated berlan!