PDA

View Full Version : Is there an Easier way to do this? Sum Sheets based on Name *



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?

Trebor76
04-18-2013, 11:15 PM
Hi menor59,

As long as you're adding the same cell a 3D formula will get the job done as such:

=SUM('Quote 1:Quote 5'!D65)

HTH

Robert