Summing values
Folks,
I am looking for some help here. I am trying to calculate a value when the following conditions are met:
If Billable = "Yes" AND Sprint = "Sprint 01" THEN SUM VALUE(Cell different sheet)/SUM ESTIMATES (this sheet where above conditions are true)*ESTIMATES value this row
I have played around with multiple different variations but feel like I am going around in circles.
=IF(Billable@row="Yes", ((IF Sprint@row, "Sprint 01", ......
The following calculation works but I don't want to have to hardcode the bold fields but to sum the values here if the two conditions above are true.
=SUM({Sysco Costs Range 2} / SUM(Estimate2, Estimate3, Estimate10, Estimate11, Estimate12, Estimate13, Estimate14, Estimate15) * Estimate2)
All help gratefully appreciated.
Answers

Are you able to provide some screenshots for context?

Thanks Paul,
Following is really the area I am having issues with. I am trying to get a straightforward multiple IF statement working first before I add it to my more complex formula. Help with this would be a starting point to getting rest of the formula working.

Hi @GerryOwens,
For your above formula, it would be this:
=IF(AND(Sprint@row = "Sprint 01", Billable@row = "Yes"), "1", "2")
If you're using numeric values rather than subbing text in for "1" & "2", the quotation marks can be removed.
I'm not sure about the ranges mentioned in your original post  do you have any more details on those (redact any sensitive data as required)?
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