Sum IF A= X or Y or Z

[stebrownsword]

hi guys

long time no speak,I would appreciate some help fine tuning this formula.

I would like the formula, SUM the WTE in Column U - if they are Div 1 stated in ColumnAA and if they are FY1, FY2 or FY3 in Column L

the formula below works to sum FY1 in Div 1 but I'm strugging to get the formula to also count if they are FY2 or FY3

=SUMPRODUCT(--(SIP!AA:AA="Div 1"),--(SIP!L:L="FY1"),SIP!U:U)

basically how to i get the formula to (SIP!L:L="FY1" or "FY2" or "FY3)


thanks in advance

 

[AlanY]

can just add them up

=SUMPRODUCT(--(SIP!AA:AA="Div 1"),--(SIP!L:L={"FY1","FY2","FY3"}),SIP!U:U))

 

[AlanY]

can just add them up

=SUMPRODUCT(--(SIP!AA:AA="Div 1"),--(SIP!L:L={"FY1","FY2","FY3"}),SIP!U:U))

may be this

=SUMPRODUCT(--(SIP!AA:AA="Div 1"),--((SIP!L:L="FY1")+(SIP!L:L="FY2")+(SIP!L:L="FY3")),SIP!U:U)

 

[Eric W]

This should be more efficient with whole-column references:

=SUM(SUMIFS(SIP!U:U,SIP!AA:AA,"Div 1",SIP!L:L,{"FY1","FY2","FY3"}))

 

[stebrownsword]

thank you so much, the may be this one formula worked, the first formula stated Value