incremental cell reference

August 29, 2011 at 21:29:16
Specs: Windows XP

XX YY zz
Hours Reason Comments Hours Reason Comments Hours Reason Comments
Jan-11 53 1
Jan-11 2
Jan-11 Week - 01 3
Jan-11 4
Jan-11 5 8 Vacation
Jan-11 6 8 Training
Jan-11 7
Jan-11 8
Jan-11 9
Jan-11 Week - 02 10
Jan-11 11
Jan-11 12 8 Vacation
Jan-11 13 8 Training
Jan-11 14
Jan-11 15
Jan-11 16


I have created an excel to capture the non-available hours of my team.
Have used the following formula to get the weekly trend for vacation alone.
=SUMIF(Sheet1!E12:E18,$B$2,Sheet1!D12:D18)

But how do i do it for the 2nd week? How to increment the cell reference?

Vacation Training
XX YY
Week - 01 8 0
Week - 02 0 0
Week - 03 0 0




See More: incremental cell reference

Report •

#1
August 30, 2011 at 02:31:40
Please click on the blue line at the end of this post, read the instructions on how to post data in this forum and then repost your data.

Use Column and Row designations so that we can tell which columns/rows your data is in. Thanks.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question