Simple SUMIF Formula Needed

[teamexcel777]

I need 2 SUMIFS formulas

I have 2 worksheets; SALES & STATS

on STATS H28 is where the formula is needed.

I need the formula to SUM S6:S1005 IF both criteria in SALES I6:I1005 = "CL" and SALES E6:E1005 = "B"

Same formula needed for Y17:Y28 with the exception of E6:E1005 = "S"

 

[Eric W]

=SUMIFS(SALES!S6:S1005,SALES!I6:I1005,"CL",SALES!E6:E1005,"B")

=SUMIFS(SALES!Y6:Y1005,SALES!I6:I1005,"CL",SALES!E6:E1005,"S")

I assumed on the second one that you meant the sum range to be Y6:Y1005. If you really did mean Y17:Y28, then you can't have a SUMIFS where the ranges are different sizes. If that's what you want, then describe the situation more fully and we'll see if there's another option.

 

[mrshl9898]

Like this?

I need the formula to SUM S6:S1005 IF both criteria in SALES I6:I1005 = "CL" and SALES E6:E1005 = "B"

=SUMIFS($S$6:$S$1005,$I$6:$I$1005,"CL",$E$6:$E$1005,"B")

 

[teamexcel777]

works great thank you

 

[Eric W]

Glad we could help.