K
Kevin Daly
Hello everyone:
First of all, thank you so much for anyone that helps.
Using XL 2000, I have two columns of numerical data; the first column
contains values from a VLOOKUP function, and the second is an
"Override" column where that value can be changed. For example, if
cell A15 has $315.00 from the Vlookup, but if it really should be
$320.00, the user types $320 in the offsetting cell B15 (so as to not
delete the formula in A15). Everything works well so far.
The problem I have is how do I tell Excel to sum at the bottom but sum
the Override column on certain cells if applicable. In other words, it
has to know that for each of the cells in range A20:A50, if there is a
value in the offsetting "B" column, it should add that one and NOT the
one in the A column.
If I were doing this manually, it would be something like
=SUM(A10:A13,B14,A15:A19,B20,B21:B30....etc where cells B14 and B20
have something in the "Override" cell. The problem is the data always
changes based on other inputs and the "Override" column could be
partly full or sometimes even completely empty. I know a formula can
work.
I hope I've been clear, and again thanks for your help.
Kev
First of all, thank you so much for anyone that helps.
Using XL 2000, I have two columns of numerical data; the first column
contains values from a VLOOKUP function, and the second is an
"Override" column where that value can be changed. For example, if
cell A15 has $315.00 from the Vlookup, but if it really should be
$320.00, the user types $320 in the offsetting cell B15 (so as to not
delete the formula in A15). Everything works well so far.
The problem I have is how do I tell Excel to sum at the bottom but sum
the Override column on certain cells if applicable. In other words, it
has to know that for each of the cells in range A20:A50, if there is a
value in the offsetting "B" column, it should add that one and NOT the
one in the A column.
If I were doing this manually, it would be something like
=SUM(A10:A13,B14,A15:A19,B20,B21:B30....etc where cells B14 and B20
have something in the "Override" cell. The problem is the data always
changes based on other inputs and the "Override" column could be
partly full or sometimes even completely empty. I know a formula can
work.
I hope I've been clear, and again thanks for your help.
Kev