Hello. If I have a bunch of rows with numbers, how can I sum up the preceding rows whenever there is a blank with a number in the row above it? Does that make sense?
So A1:A3 numbers= sum A1:A3 in A4 A7:10 numbers= sum A7:A10 in A11
Hello. If I have a bunch of rows with numbers, how can I sum up the preceding rows whenever there is a blank with a number in the row above it? Does that make sense?
So A1:A3 numbers= sum A1:A3 in A4 A7:10 numbers= sum A7:A10 in A11
Why do I have the feeling this forum is doing your job for you?
Please Login or Register to view this content.
If you are happy with my response please click the * in the lower left of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks