D
DiSalvo
I have multiple sheets one for each month. I have a summary page that needs
to sum the sheets by row. The column controls the date range which is being
used to dynamically produce the end of the date range to sum. I have a work
book example that I can share. please let me know if you need to see it.
Please do not Use the SHEET:A1:AG - sum function.
dynamically it needs to find a date in a row in a certain column. The first
sheet is Jan the second is Feb and so on. If I were to use on the scroll bar
3/31/09 - I should be able to sum Jan (row) + Feb (row) + mar(row) only where
the month numbers intersect. And each row I choose needs to be summed on the
summary page. The sheet has the position in column A6 through A20. rate is in
col "B" and the hours to be summed are in C through AG. one for each day of
the month.
I can send the workbook and formulas too.
to sum the sheets by row. The column controls the date range which is being
used to dynamically produce the end of the date range to sum. I have a work
book example that I can share. please let me know if you need to see it.
Please do not Use the SHEET:A1:AG - sum function.
dynamically it needs to find a date in a row in a certain column. The first
sheet is Jan the second is Feb and so on. If I were to use on the scroll bar
3/31/09 - I should be able to sum Jan (row) + Feb (row) + mar(row) only where
the month numbers intersect. And each row I choose needs to be summed on the
summary page. The sheet has the position in column A6 through A20. rate is in
col "B" and the hours to be summed are in C through AG. one for each day of
the month.
I can send the workbook and formulas too.