PDA

View Full Version : Formula Possible



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 :)

Bob Phillips
03-03-2008, 03:16 PM
2007 is not a sequence witin a date, it is the year. And what value would you add in?

bopo
03-03-2008, 03:20 PM
Well there will already be values in column J, is just a case of adding them up and placing the final value in a cell where the date on that particular row equals 2007

And a separate cell to do the same where the date equals 2008, so basically both the same thing , they just evaluate against different expressions

Bob Phillips
03-03-2008, 03:57 PM
You won't do this with a formula, it would best be done wit worksheet event code.

Can the user change the value in M, and what sould happen if they do?