Summing Range
 

HI,
i am looking for a way to sum columns of data, until they hit a specific
number, then after that point quit summing them and remove the data not
needed.

A B C D E F G H
ID Ja Fe Ma Ap Ma Ju Tot
23 4 8 6 9 1 28

so basically i want it to sum column B and C, check to see if its totally
24, if not continuing summing until you hit 24. Then delete the values over
24.

thoughts?
thanks for any ideas!
--
Angel