A B C
1 12 14
2 15 14
3 12 15
4 12 15 14

This is the data I have to work with. I need help with getting a formula to
do the following:
1) Take Column A and Column B. If both coloums have #'s in them, I would
like the value of Column A to show up in Column A5. (EXAMPLE: since Column
A3&B3 and Column A4&B4 have #'s take Column A3 & Column A4 values and add
and put in Column A5=24.
Any information will help,
Thanks,
al619