A
Angel H
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!
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!