total amounts acquired through formula's referencing other sheet

P

PVUMIGQS

When I try to use =SUM ( : ), to get a total for amounts which were
calculated using formulas referencing amounts on another sheet, nothing
happens (I do not get a total).
 
G

Gord Dibben

Show us the actual formula you are using.

=SUM(Sheet2!A1:A10) works for me.


Gord Dibben MS Excel MVP
 
Top