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...
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...