summarize

[Guest]

I want to do the following but i don't find the way:
i have in one sheet the following :
b100 part1 5
b200 part2 10
b100 part1 12
b200 part2 23
b300 part3 18
b200 part2 11
b300 part3 6

how can i get in the second sheet automaticaly that he makes the sum of the
equal bnumbers?

Thanks

Verfaille Bruno

 

[Guest]

Hi Bruno,

In sheet2
column A B
b100 =SUMPRODUCT(--(Sheet1!A$1:A$7=A1);Sheet1!C$1:C$7)
and all other fill down
b-number


Regards,
Stefi


„Bruno†ezt írta:

 

[Tom Ogilvy]

=sumif(Sheet1!A:A,"b100",Sheet1!C:C)

You can get a list of unique numbers in column A (or B) by using the
Advanced filter with the unique checkbox selected. You could then refer to
this list using the above formula by replacing "b100" with a cell address
for a cell containing the entry B100 (in the Unique list)

=sumif(Sheet1!A:A,Sheet2!A3,Sheet1!C:C) for example. (where Sheet2!A3
contains the string b100)