Need help for SUMPRODUCT

[bhasoriya]

I have tried sumproduct formula but there is some mistake.. Please guide me.

 

[Haseeb A]

Hello,

Try this version in M8 & copy down.

=SUMPRODUCT((J$2:J$60="Special")*(F$2:F$60=K8),1/COUNTIFS(B$2:B$60,B$2:B$60,J$2:J$60,J$2:J$60,F$2:F$60,F$2:F$60))

 

[bhasoriya]

Hello Haseeb,

Thanks a ton... it's working perfect.. Thank you.