NEED HELP WITH A FORMULA PROBLEM

[al619]

A B C
1 13 21
2 23 13
3 13
4 4 32
5 14 15

Please help with this formula. Example: B2 & C2 both have numbers and also
Columns B5 & C5. Since both of these columns have #'s in them I would like
B2&B5 to add together in a different column.

Thank you for any input,
al619

 

[Lars-Åke Aspelin]

A B C
1 13 21
2 23 13
3 13
4 4 32
5 14 15

Please help with this formula. Example: B2 & C2 both have numbers and also
Columns B5 & C5. Since both of these columns have #'s in them I would like
B2&B5 to add together in a different column.

Thank you for any input,
al619

A1 & C1 also have numbers, and so have A4 & B4.
What do you want to do with them?
You only mention B2 & C2 and B5 & C5. What is special with them?

Please explain more what result you expect.

/ Lars-Åke

 

[dlw]

=IF(B2>0,IF(C2>0,IF(B5>0,IF(C5>0,B2+B5,""),""),""),"")

 

[al619]

I would like the forluma to take all of column B & C information and if there
are any #'s in both Columns B & C to take Column B # and place it in B6.
Example: since B2(#23)&C2 AND B5(#14)&C5 both have #'s in columns, B6 = 27
Thank you all for any help,
al619

 

[al619]

Sorry if I am using the wrong termanology. They are not columns but cells.
Thanks,
al619

 

[Lars-Åke Aspelin]

In cell B6:

=SUMPRODUCT((B1:B5)*ISNUMBER(C1:C5))

which basically the same solution as already given in the thread "Help
on formula".

Hope this helps / Lars-Åke

 

[al619]

Thank you.
I will try it out and let us see.

In cell B6:

=SUMPRODUCT((B1:B5)*ISNUMBER(C1:C5))

which basically the same solution as already given in the thread "Help
on formula".

Hope this helps / Lars-Ã…ke