#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.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives