2

Hello All,

I am trying to sum to condition together from another sheet. I am looking to sum hour estimates when sprint name "01 2019" and Account "US Professional Services". I am able to get it to calculate on the first condition but when I am the second condition, I get  #unparseable

Here is the formula. 

=SUMIFS({Adient Backlog Range 1}, {Adient Backlog Range 2}, "01 2019", [{Adient Backlog Range 3}, "US Professional Services" ])

Comments

Hi dcharnin,

I am not 100% sure if I get your question right, but when using text you have to make a comparison. Something like this:

 

=SUMIFS({Adient Backlog Range 1}, {Adient Backlog Range 2}, "01 2019", (@cell= "US Professional Services") )

Try using your original formula but remove the brackets surrounding your added argument.

=SUMIFS({Adient Backlog Range 1}, {Adient Backlog Range 2}, "01 2019", {Adient Backlog Range 3}, "US Professional Services")

See if that works. :)