Google Spreadsheet Post #1878
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-07-2015
post by mintoc:
https://productforums.google.com/forum/#!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 /.
---
https://productforums.google.com/forum/#!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
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)
No comments:
Post a Comment