Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Master Worksheets and Individual Worksheets | Excel Worksheet Functions | |||
Sum worksheets - w/o updating formula for new worksheets which are | Excel Worksheet Functions | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |