Forum Discussion
IF / Countif / Sumif - Formula help please
I can't get this if function to do what I want. What am I doing wrong? Column C. I'm trying to get the column to add one for every row through the number at the top of the sheet (20, 26 etc) ...
Example data and formula
=IF(AND($C12+1<=$C$2,IF($B13="",$C12+1)),IF(AND(C12=0,C11=0),C10+1),C12+1)
| util 1 | util 2 | ||
| 20 | 26 | ||
| READ DATE | HOLIDAY/WEEKEND | CYCLE | |
| Sunday, January 01, 2017 | YES | ||
| Monday, January 02, 2017 | YES | ||
| Tuesday, January 03, 2017 | 1 | 1 | |
| Wednesday, January 04, 2017 | 2 | 2 | |
| Thursday, January 05, 2017 | 3 | 3 | |
| Friday, January 06, 2017 | 4 | 4 | |
| Saturday, January 07, 2017 | YES | 0 | 0 |
| Sunday, January 08, 2017 | YES | 0 | 0 |
| Monday, January 09, 2017 | 5 | 5 | |
| Tuesday, January 10, 2017 | FALSE | 6 | |
| Wednesday, January 11, 2017 | FALSE | 7 | |
| Thursday, January 12, 2017 | FALSE | 8 | |
| Friday, January 13, 2017 | FALSE | 9 | |
| Saturday, January 14, 2017 | YES | 1 | 0 |
| Sunday, January 15, 2017 | YES | 2 | 0 |
| Monday, January 16, 2017 | FALSE | 10 | |
| Tuesday, January 17, 2017 | FALSE | 11 | |
| Wednesday, January 18, 2017 | FALSE | 12 |
Hi Chris,
Will try to play tomorrow if no one answers before. What 20 and 26 means under util 1 and util 2?
Thank you. Much appreciated.
Will try to play tomorrow if no one answers before. What 20 and 26 means under util 1 and util 2?
The 20 or 26 is the number to that the count should reach before starting back at 1.
Does that make sense?