LinkBack URL
About LinkBacks
Hi
need help with formula
count until the condition is met and restart the count
and the result must be on same row with condition on column B
Hi
need help with formula
count until the condition is met and restart the count
and the result must be on same row with condition on column B
Last edited by pedersenn; 10-02-2022 at 05:34 PM.
You can use this formula in E5:
=IF(B5="restart count",IFERROR(MATCH("restart count",B6:B$28,0),COUNTA(C5:C$28)),"")
Copy down to E27.
Hope this helps.
Pete
I don't understand, the results 4, 6, 3 and 10 and has sheet 2 with the 7 also something to do with it?
Please could you give a more concrete example with explanation?
Last edited by HansDouwe; 10-02-2022 at 06:07 PM.
Removed by myself (duplicate post)
Last edited by HansDouwe; 10-02-2022 at 06:08 PM.
The problem is solved with this formula: =IF(B5="restart count",IFERROR(MATCH("restart count",B6:B$28,0),COUNTA(C5:C$28)),"")
The second sheet has nothing to do with the first, it is by mistake.
Formula counts until next condition on column B.
Is 4 because there are 4 rows up to the first condition on column B.
Last edited by pedersenn; 10-02-2022 at 09:47 PM.
Glad to help, and thanks for the rep.
If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks