Wednesday, January 7, 2015

yogi_Count Cells With A Particular Text Since A Cell With Another Specific Text

             Google Spreadsheet   Post  #1878
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-07-2015
post by  mintoc:!category-topic/docs/spreadsheets/TaaKvW6aN5M
How to count cells with a particular word since a cell with another different word
So imagine you have a row with cells filled with x. Only sometimes it has to be interuped by an /.
I was wondering if there was any way to use a function to count the amount of cells filled with an x since the last cell with an /.

Depends really
I would like to use the sheets to keep track of habits i'd like to do every day. So every evening I need to check a habit with an x, but if I don't complete it that day, It would be marked with an /. But this way keeping track of how many times I completed the habit in a row, since the last time I didn't(so a cell filled with an /), is really hard. So I was wondering if there was an automatic way to count the cells filled with x since the last non completed day.

I hope the files makes it clearer
Attachments (1)

7 KB   View   Download