Hi there,

I am try to summarise data from one worksheet to another:

Raw Data:
Change ID A B C D
1001 1 0 0 0
1001 1 1 0 0
1002 0 0 0 1
1002 0 0 0 1
1002 0 0 0 1
1003 0 0 0 1
1004 1 1 0 0
1004 1 0 0 0
1004 0 0 1 1

Summary:
Change ID A B C D
1001
1002
1003
1004

TASK - need to populate the summary with the totals for A,B,C&D for each change.
Not sure if this is a vlook up then sumproduct - I cant do multiple formulas and this is confusing me - if anyone can help please let me know.

thanks,
Naz