sumifs not working

[FreakyGirl]

hello

having a small problem with my SUMIFS.

it looks right so need another set of eyes to see what I'm doing wrong.

=SUMIFS($Z$3:$Z$503,$X$3:$X$503,$BA3,$Y$3:$Y$503,"WA",$Y$3:$Y$503,"WS")

I want to formula to look in column X & find the name specified BA. then sum any figures in column Z where column Y contain either WA or WS.

i have tried using logical operators for BA3 & putting it in quotes to no avail.

The formula is located in column BI.

I do have to add more 'IFS' in using the adjacent colored columns but thought I would get the first one working before I attempted that.

thanks,
FreakyGirl

 

[Chihiro]

Try...
=SUM(SUMIFS($Z$3:$Z$503,$X$3:$X$503,$BA3,$Y$3:$Y$503,{"WA","WS"}))

 

[FreakyGirl]

Try...
=SUM(SUMIFS($Z$3:$Z$503,$X$3:$X$503,$BA3,$Y$3:$Y$503,{"WA","WS"}))

thanks for the quick reply & answer.

now i need to check for the name in column BA in the other colored sections.

i adapted your formula & made 3 other COUNTIFS() in the same SUM().

=SUM(SUMIFS($Z$3:$Z$503,$X$3:$X$503,$BA3,$Y$3:$Y$503,{"WA","WS"})+SUMIFS($AG$3:$AG$503,$AE$3:$AE$503,$BA3,$AF$3:$AF$503,{"WA","WS"})+SUMIFS($AN$3:$AN$503,$AL$3:$AL$503,$BA3,$AM$3:$AM$503,{"LA","LS"})+SUMIFS($AU$3:$AU$503,$AS$3:$AS$503,$BA3,$AT$3:$AT$503,{"LA","LS"}))

is this the way to do this or could i have included the other criteria in the inital SUMIFS()? i wasnt sure how to keep the BA intact for the name but substitute out the other columns.

thanks,
FreakyGirl