menor59
04-18-2013, 08:52 PM
I have the following formula:
='Quote 1'!$D65+'Quote 3'!$D65+'Quote 2'!$D65+'Quote 4'!$D65+'Quote 5'!$D65
Is there a way to have it do Something along the lines of
=SUM(Quote*$d65)
basically Look at any sheet that is named Quote and dum those Cells up?
='Quote 1'!$D65+'Quote 3'!$D65+'Quote 2'!$D65+'Quote 4'!$D65+'Quote 5'!$D65
Is there a way to have it do Something along the lines of
=SUM(Quote*$d65)
basically Look at any sheet that is named Quote and dum those Cells up?