NEED HELP WITH A FORMULA PROBLEM
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
|