Hello, I am hoping to get help with a formula that will sum a set of cells, unless there is a value present in the cell to the right.
More specifically, I have a spreadsheet that lists an "estimated" number for the month followed by the "actual" number for the same month. I would like to total by quarter, the values in the estimated cell, but once values are placed in the actual cell I would like the formula to use that value instead.
I thought I was getting somewhere with this formula:
=SUM(B4="0",A4,B4)
A4 = January Estimate
B4 = January Actual
This worked well for January only. When I try to add the other months I'm not getting the result I'm after. I tried nesting etc, I'm positive I just don't know the proper way to carry this through each of the three month grouping to arrive at the total for the quarter.
Any help is very appreciated, thank you!
More specifically, I have a spreadsheet that lists an "estimated" number for the month followed by the "actual" number for the same month. I would like to total by quarter, the values in the estimated cell, but once values are placed in the actual cell I would like the formula to use that value instead.
I thought I was getting somewhere with this formula:
=SUM(B4="0",A4,B4)
A4 = January Estimate
B4 = January Actual
This worked well for January only. When I try to add the other months I'm not getting the result I'm after. I tried nesting etc, I'm positive I just don't know the proper way to carry this through each of the three month grouping to arrive at the total for the quarter.
Any help is very appreciated, thank you!
