bopo
03-03-2008, 03:03 PM
Hi
Well basically I want to create a formula to do several things, however coming from a programming background, I am not sure how to go about it.
I have a column (M8:M27) with dates ranging between the year 2007 (e.g. 12/08/2007) and 2008 (06/06/2008). I would like a formula to do the following
Look in the cell range M8:27
If cell contains numeric sequence '2007', then goto column J (within same row) and add the value to a cell, this should loop so that each value found within a J column (per 2007 found in column M) is added to a running total until there are no more
Same for a 2008 date, except using a different cellHope that makes sense for you experts :)
Well basically I want to create a formula to do several things, however coming from a programming background, I am not sure how to go about it.
I have a column (M8:M27) with dates ranging between the year 2007 (e.g. 12/08/2007) and 2008 (06/06/2008). I would like a formula to do the following
Look in the cell range M8:27
If cell contains numeric sequence '2007', then goto column J (within same row) and add the value to a cell, this should loop so that each value found within a J column (per 2007 found in column M) is added to a running total until there are no more
Same for a 2008 date, except using a different cellHope that makes sense for you experts :)