What formula can be used to ensure that the count function will reset once meeting a condition
Example:
A B
1
1
1
1
1
0 5 <-- Count
1
1
0 8 <-- I want this value to be 2 because i only want it to count the 1 and once there is a 0, I want the count to reset.
All help is appreciated thanks in advance
Start from B2 then drag down:
=IF(A2=0,COUNTIF($A$1:A2,1),"")
Untitled.png
Quang PT
Hi bebo021999,
Thanks for the reply but this formula is not working for some reason.
I still get "7" on cell B9 instead of "2".
bebo.PNG
hi Jepri, try below with slight modification
=IF(A2=0,COUNTIF(A$1:A2,1)-SUM(B$1:B1),"")
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
Try with a helper column.
B2Formula:
Please Login or Register to view this content.
C2Formula:Please Login or Register to view this content.
Row\Col Data HelperColumn Result
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thanks Alvin that formula works.
Thanks Shukla for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks