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

On Sat, 13 Dec 2008 11:03:01 -0800, al619
wrote:

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

=IF(B20,IF(C20,IF(B50,IF(C50,B2+B5,""),""),"") ,"")

"al619" wrote:

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

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

"Lars-Ã…ke Aspelin" wrote:

On Sat, 13 Dec 2008 11:03:01 -0800, al619
wrote:

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

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

"al619" wrote:

I would like the formula 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

"Lars-Ã…ke Aspelin" wrote:

On Sat, 13 Dec 2008 11:03:01 -0800, al619
wrote:

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

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

On Sat, 13 Dec 2008 15:12:00 -0800, al619
wrote:

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

"Lars-Åke Aspelin" wrote:

On Sat, 13 Dec 2008 11:03:01 -0800, al619
wrote:

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

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

"Lars-Ã…ke Aspelin" wrote:

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

On Sat, 13 Dec 2008 15:12:00 -0800, al619
wrote:

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

"Lars-Ã…ke Aspelin" wrote:

On Sat, 13 Dec 2008 11:03:01 -0800, al619
wrote:

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