Summing values

GerryOwens

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.

Paul Newcome

Are you able to provide some screenshots for context?

GerryOwens

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.

Nick Korna

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)?