tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,913
- Office Version
- 365
- 2019
- Platform
- Windows
On my worksheet, cells A1 through to B6, I have the values 1,2,3,4,5,6 from A1, A2, A3, etc.
In cell D1, I type:
and enter it as an ARRAY formula to get the result of:
I understand how this is arrived. It is multiplying cell A1 with B1, then A2 with B2 and then A3 with B3, then summing it, ie 4+10+18=32.
However in cell D2, if I typed:
but this time I enter it as a NORMAL formula, I get the result of:
What exactly is Excel doing to get the value of 10?
Thanks
[/FONT]
In cell D1, I type:
Rich (BB code):
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=SUM(A1:A3*B1:B3)
and enter it as an ARRAY formula to get the result of:
Rich (BB code):
32
I understand how this is arrived. It is multiplying cell A1 with B1, then A2 with B2 and then A3 with B3, then summing it, ie 4+10+18=32.
However in cell D2, if I typed:
Rich (BB code):
=SUM(A1:A3*B1:B3)
but this time I enter it as a NORMAL formula, I get the result of:
Rich (BB code):
10
What exactly is Excel doing to get the value of 10?
Thanks
[/FONT]