Hello All,
I need a formula that will look at 3 columns of data and return a sum based on the following understanding:
If C1 is blank, look at A1 + B1 and return a sum; otherwise, return the value in column C1. I need it to do this down the entire column and return the total sum. Essentially, columns A1 and B1 are budget numbers and C1 will be the actual number once I have identified it. C1 will trump A1 + B1 at that point.
Column A Column B Column C Answer
125 362 = 487
50 623 = 623
450 =450
500 750 =750
sum total = 2,310
Bookmarks