Help on formula

[al619]

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

 

[Lars-Åke Aspelin]

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

A3, A4 and A5 are not columns, they are cells, so I assume that you
mean cell A5 etc.

In cell A5 you may try the following formula:

=SUMPRODUCT((A1:A4)*ISNUMBER(B1:B4))

Hope this helps / Lars-Åke

 

[Sheeloo]

Try

=SUMPRODUCT(--(B1:B4<>""),(A1:A4))

This will add cells in A1:A4 where B1:B4 is not blank