N
Neil Pearce
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
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