countif for multiple criteria

[r_2]

Hi,

Unable to do it, with multiple criteria range.

1) countifs require for sales(column C, against column A, mgr)

Required to find out count of sales against mgr, but store location should be required to taken in critera to find the count as 2 mgrs are taking care of same location

 

[Hui]

Use the Countifs() function

 

[Deepak]

Is this...
=SUMIFS(C7:C20,A7:A20,F6)

 

[Hui]

or =SUMPRODUCT((A7:A20=F6)*(C7:C20))

 

[r_2]

or =SUMPRODUCT((A7:A20=F6)*(C7:C20))

Hi hui,

I need the count of row. pls reply. Thnx

 

[r_2]

Is this...
=SUMIFS(C7:C20,A7:A20,F6)

Hi Deepak,

I need the count of row. pls reply. Thnx

 

[Somendra Misra]

Hi r_2,

Try:

=SUMPRODUCT(($A$7:$A$20=$F$6)*($C$7:$C$20<>"")) in H6 and copy down.

Regards,

 

[Deepak]

Hi,

=COUNTIFS($C$7:$C$20,">0",$A$7:$A$20,F6)