countifs

[srirajsa]

Sir

I want to match three three criteria and get count for example


Location Designation October November Decmber

XYZ SM 4500
XYZ SM 2500
XYZ SM
XYZ ASM 1500
XYZ ASM
XYZ SM
ABC ASM

Sir I want to COUNT in XYZ location how many achieved more than 0 by designation wise
like SM 2 and ASM 1 by monthwise

Thanks & regards

Srinivas

 

[JawaharPrem]

Hi Srini,

your required like this.

Regards
Jawahar Prem