Counting using child rows
I have sheet with several parents and children
Day 1(Rows 1-20)
Time A (rows 3-5)
Time B (Rows 7-9)
Time C (Rows 11-20)
Day 2 (rows 21-48)
Time A (rows 22-27) ETC ETC
Rows could be added to any of the time slots at any time.
I want to keep a real time count of how many are in each time slot
If I want a count t of "Day 1 Time B" I can do a =Count(Primary7:Primary9) .But if another row gets added for that time slot, becoming row 10, the formula will not update AND the formulas for the slots below will no longer be accurate as well.
Is there a way to get around the row range problem for real time counting?
Help Article Resources
Check out the Formula Handbook template!