SUMIFS formula help

[rikvny02]

I need to add an addition condition to the below formula. I'd like to only pull the total from if A:A = E2. Any help would be grateful. Thanks.

G2: =IF(SUMIFS(C:C,B:B,">="&E5,B:B,"<="&F5)=0,"",(SUMIFS(C:C,B:B,">="&E5,B:B,"<="&F5)))

 

[Joe4]

SUMIFS is not limited to two conditions, you can add more, i,e,

SUMIFS(C:C,B:B,">="&E5,B:B,"<="&F5,A:A,E2)

 

[rikvny02]

SUMIFS is not limited to two conditions, you can add more, i,e,

SUMIFS(C:C,B:B,">="&E5,B:B,"<="&F5,A:A,E2)

Just an FYI. The formula is in "G6" not g2.

I tried your formula and it returns "$0". I would expect a return value of $336 coming from cell "C4"

ps. sorry I cant use the XL2BB at work.

 

[Joe4]

I didn't post the whole formula, I was just showing you how you can add more arguments to SUMIFS, figuring you should be able to do that is both spots of your formula, i.e.
for G2:

=IF(SUMIFS(C:C,B:B,">="&E5,B:B,"<="&F5,A:A,$E$2)=0,"",(SUMIFS(C:C,B:B,">="&E5,B:B,"<="&F5,A:A,$E$2)))

(note that since you appear to be wanting to copy this formula to other cells, and always want to look in cell E2, we should "lock" the E2 reference down with the dollar signs before the row and column references, like I show above)

 

[rikvny02]

I didn't post the whole formula, I was just showing you how you can add more arguments to SUMIFS, figuring you should be able to do that is both spots of your formula, i.e.
for G2:

=IF(SUMIFS(C:C,B:B,">="&E5,B:B,"<="&F5,A:A,$E$2)=0,"",(SUMIFS(C:C,B:B,">="&E5,B:B,"<="&F5,A:A,$E$2)))

(note that since you appear to be wanting to copy this formula to other cells, and always want to look in cell E2, we should "lock" the E2 reference down with the dollar signs before the row and column references, like I show above)

Hand to forehead. I was not hitting F4 and locking cell E2. Sometimes its right in front of your face and u cant see it