Possibly SUMIF-function related

[ElongatedEconomist]

Hello,

I am trying to sum up a column with some budget-numbers, and if there has been a revised budget, use that cell instead of the original.
Basically two colums:

A - Budget B - Revised

1 3
2
3 1
4

Is it possible, or do I have to go the route of an IF-function for row, and then add all the functions together?

 

[Joe4]

Welcome to the Board!

If I am understanding you correctly, and your data is in Range A2:B5, try this formula:

=SUM(B2:B5)+SUMIF(B2:B5,"",A2:A5)