<img src=/S/confused.gif border=0 alt=confused width=15 height=20>
I will attempt to make this simple....
A2..A500 contains data (each cell WILL contain data)
M2..M500 will contain DATES (NOT every cell will contain a date)
For example: M5 might have 6/24/01 but M6..M10 wont contain a date..M11 will have 6/25/01.
What I am attempting to do is create a formula (or function) and put it in N5..therefore when N5 sees there is a date in M5 start counting all the values beginning with A5 and stop counting at A10 because the date changes in M11 ...in this case the count (total) in N5 would be 5. The count starts over beginning in A11 because the new date is in M11...and so on.
If this is too confusing, please post back and I will try to make it more clear.
I appreciate any suggestions.