Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 109
Default Sum Worksheets

Having searched and read similar queries regarding summing there was a
reference to the website: http://www.mcgimpsey.com/excel/threedsumif.html

Adapting the formula provided and (with great originality) naming my
worksheets to sum, "worksheets_to_sum", the following formula works great.

=SUMPRODUCT(SUMIF(INDIRECT("'"&Worksheets_To_Sum&" '!A14:A23"),$A19,INDIRECT("'"&Tabs&"'!B14:B23")))

However I wish to copy and paste the formula to several other columns so
that columns C onwards can be summed. In its current form the sum range
remains static at B14:B23.

I attempted to correct this by adding a header row that would indicate the
column to be summed, e.g. Cell D17

=SUM(...INDIRECT(" ' "&Tabs&" ' ! & D17 & "14:" & D17 & "23")))

This did not work. Any ideas?


Thanking-you,

Neil


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Master Worksheets and Individual Worksheets PADutchFireman Excel Worksheet Functions 1 April 2nd 09 05:59 PM
Sum worksheets - w/o updating formula for new worksheets which are Elgee Excel Worksheet Functions 4 August 15th 08 05:51 PM
How use info in Excel shared worksheets to create new worksheets dkc Excel Worksheet Functions 0 June 28th 07 08:36 PM
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? TS Excel Worksheet Functions 2 December 27th 06 02:49 PM
Assigning Cells in worksheets to other data in other worksheets. David McRitchie Excel Discussion (Misc queries) 0 November 27th 04 06:15 PM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"