I currently have a formula that sums up numbers in an adjacent cell until there is a blank row and repeats this process. however, the way i have it at the moment, the formula keeps adding up even after the cells that show a 0. I have attached the excel file that hopefully conveys the message better and the goal i am trying to achieve.
Hi,
maybe this:
Formula:
Please Login or Register to view this content.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Ooooh, very cool formula. How could i modify this to read the summation at the top of the grouping? I attached a new spreadsheet.
D19
copied down.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks