Need help Summarizing Moving values in Summary Sheet

J

Jim_4705

Can anyone Help.

Trying to create a formula that will allow me to Sum up a
cell in a summary sheet based on the values that may
appear anywhere in a range of cells in multiple sheets.

Example

Sheet1

a1=apple b1=20
a2=orange b2=10
a3= pear b3=5

Sheet2

a1=grape b1=30
a2=pear b2=15
a3=apple b3=40

SummarySheet
'(looking for unique a column values to appear;
apple,grape, pear,orange)

a10=apple b10=(40+20)=60
a11=pear b11=(15+5)=20
etc...

A

Anon

Jim_4705 said:
Can anyone Help.

Trying to create a formula that will allow me to Sum up a
cell in a summary sheet based on the values that may
appear anywhere in a range of cells in multiple sheets.

Example

Sheet1

a1=apple b1=20
a2=orange b2=10
a3= pear b3=5

Sheet2

a1=grape b1=30
a2=pear b2=15
a3=apple b3=40

SummarySheet
'(looking for unique a column values to appear;
apple,grape, pear,orange)

a10=apple b10=(40+20)=60
a11=pear b11=(15+5)=20
etc...

I would use SUMPRODUCT to do this for each sheet and then just add them up.