SUMIFS with 2 Criterias

[sureshsonti]

I have 3 columns with date, plant and quantity sold. Want to use SUMIFS and convert the date field to month names and sum quantity sold based on plant location.

=sumifs(quantity sold,TEXT(datecolumn,"mmm"),MonthColumn,plantcolumn,plantname)

not a working formula.

 

[bosco_yip]

Try,

B29, copied across and down :

=SUMPRODUCT((MONTH(date)=MONTH(0+("1/"&$A29)))*(plant=B$28),yardage)

Or,

if you want to use SUMIFS, try this in B29 :

=SUMIFS(yardage,date,">="&0+("1/"&$A29),date,"<="&EOMONTH(0+("1/"&$A29),0),plant,B$28)

Regards
Bosco

 

[sureshsonti]

Mr. Bosco,
Both of your formulas worked great. Really appreciate your help.

Again Thank You