Hello everyone, I have a question regarding sum. I have several rows of data and I want to have a function which will help to have the sum of the numbers in a row after the latest 1 number in the columns.*
For example if you look at the first row there are three 1's and i want to have the sum after the latest 1 which is oct 21-pm and similarly for rest.
Please help me with this?
Last edited by AliGW; 05-06-2022 at 03:24 AM. Reason: Title changed - please think more carefully about your thread titles in future!
What is the expected result of AF2 cell?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
... and if there isn't a "1" in the row?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
In AF2 copied down:
=SUMPRODUCT((COLUMN($A2:$AE2)>LOOKUP(2,1/($A2:$AE2=1),COLUMN($A2:$AE2)))*$A2:$AE2)
You may wish to update your profile - I think you meant to type 365, not 360 (there is no 360).
Please take a moment to read the forum rules. I have updated your thread title to bring it into line with our expectations.
Last edited by AliGW; 05-06-2022 at 03:26 AM. Reason: Note about thread titles.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If 1 is a valid value for the SUM for a month, then you will need something a bit more complicated:
=IFERROR(SUM(INDEX($A2:$AE2,AGGREGATE(14,6,COLUMN($A2:$AE2)/(($A2:$AE2=1)*(ISNUMBER(SEARCH("Count",$A$1:$AE$1)))),1)+1):AE2),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you so much everyone. My query has been solved now.
If you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks