silverbullitt
New Member
- Joined
- Aug 28, 2014
- Messages
- 8
I have two ranges of cells, and want to sum the lowest of the two values. So, I want to sum two columns, like the example below. Blanks are intentional
I want to determine a formula to return a sum of 520 (100+150+50+40+80+100)- it picks the value in column 2 if there is one, otherwise it picks the value in the first column. I'm not an excel pro, so sorry if this is easy. I've been looking at sumif but it's got me all kinds of confused.
Code:
Budget Actual
100
150
200 50
100 40
80
70 100
I want to determine a formula to return a sum of 520 (100+150+50+40+80+100)- it picks the value in column 2 if there is one, otherwise it picks the value in the first column. I'm not an excel pro, so sorry if this is easy. I've been looking at sumif but it's got me all kinds of confused.