Hi,
Need a little help on the formula to sum amount until non blank cell of another column. e.g. to sum value in column B starting from the first cell that has value in column A until all blank cell below and stop at before the next cell with value. Attached the example.
Any help is much appreciated.
Put in C1 and copied down:
=SUMPRODUCT((LOOKUP(ROW($A$1:$A$16),(1/($A$1:$A$16<>"")*ROW($A$1:$A$16)),$A$1:$A$16)=A1)*$B$1:$B$16)
Many thanks, Azumi. It works.
awesome, this is what i'm looking for..
thank you very much buddy..
C2=IF(A2<>"",A2,C1) and drag down.
After that a sumformula or a pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Cell C1 formula , Drag down
Formula:
=IF(A1="","",SUM(B1:B$20)-SUM(C2:C$20))
Please watch this animation teaching file FILE name as S21.gif
After the file is downloaded and decompressed, you can use the left mouse button to click twice to watch the teaching file (video) or open it with explorer.
Last edited by wk9128; 06-15-2022 at 08:19 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks