Hi
I need help with a formula to count a specified data after a reference point and restart counting when the reference point is meet.
Hi
I need help with a formula to count a specified data after a reference point and restart counting when the reference point is meet.
Please explain the expected results. How did you manually calculate 3 for cell B5???
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.
I think I worked it out. Try this in B5 copied down:
=IF(A5="RF",COUNTIF($A5:$A$42,"B")-SUM($B6:$B$42),"")
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks for the rep.
Your follow-on question should be asked here.
Administrative Note:
Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
See attached with a couple of helper columns
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
See attached with a couple of helper columns
Using this formula I can get the result with fewer help columns.
Last edited by pedersenn; 12-03-2021 at 05:13 AM.
Are you still using Excel 2016?
yes, excel 2016
I will install a newer version.
If you get MS365 or Excel 2021, you can use this:
=FILTER(D:D,D:D<>"")
Remember you can hide the helper column.
This function seems to be invalid: =FILTER(D:D,D:D<>"") I'm using office Professional plus 2019
There is only the filterxml function.
Yes, as I said in my previous post, it works in Excel 2021 and MS365. Excel 2019 did not have it.
If 2019 doesn't have =FILTER then you'll have to stick with the functions you do have.
Did you try the suggestion I gave in #8?
I tried it works but I prefer the version with fewer help columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks