ARRAY FORMULA FOR TOTAL

[Maurizio]

1.xls
	A	B	C	D	E	F	G
1	10101	2		COD	TOTAL
2	10102	2		10000	9
3	10201	2		20000	12
4	10202	3		30000	14
5	20101	4		40000	18
6	20201	4		50000	24
7	20202	4
8	30110	6		WHATARRAYFORMULAISNESESSARY
9	30112	8		FORTOTAL?
10	40101	6
11	40102	6
12	41001	6
13	50101	8
14	50201	8
15	50301	8
Chiusura (2)

 

[plettieri]

Hello: maurizio.rota

Just as a matter of interest, what was the solution that best fit your needs of the solutions offered/

pll

 

[Maurizio]

For me is:

=SUMPRODUCT((LEFT($A$1:$A$15)=LEFT(D2))+0,$B$1:$B$15)

by Aladin

 

[Maurizio]

Hi, is there some real difference between "+0" and "*1":

=SUMPRODUCT((LEFT($A$1:$A$15)=LEFT(D2))+0,$B$1:$B$15)
=SUMPRODUCT((LEFT($A$1:$A$15)=LEFT(D2))*1,$B$1:$B$15)

 

[Aladin Akyurek]

On 2002-10-23 13:18, maurizio.rota wrote:
Hi, is there some real difference between "+0" and "*1":

=SUMPRODUCT((LEFT($A$1:$A$15)=LEFT(D2))+0,$B$1:$B$15)
=SUMPRODUCT((LEFT($A$1:$A$15)=LEFT(D2))*1,$B$1:$B$15)

No, both coerce logical values into 1's and 0's, but +0 looks nicer (to me, that is).