#unparseable
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.