Nested IFs

This formula in L12:
=IF(AND(ISNUMBER(B12),ISTEXT($A12)),L11+1,L11)

...makes the following requirements to increment:

1) B12 must have a number in it (it is blank, so this formula will fail and remain zero)
2) $A12 must have a text in it (Has "Mike" so this works)
3) If 1 & 2 are both true, then L12 will look up to L11 and add 1. If not, it reflects the value in L11 again.

So, only the first row of 4-row group can increment because I've removed the extra text from column A and there is only text in the first row of each group. (notice I took out the word "total"?).

The indexes on the various pages are matching the first instance of each index number on the schedule in the appropriate key column to the index in column A of the daily sheet. This simple match makes it easy to find the row of data to display on each line.
=========
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)