I am banging my head over this formula. I need to count the empty vs non-empty cells in a row (<-that's easy). The problem is, I need the count to start at the first non-empty cell in the row. For example:
Jan Feb Mar Apr May Empty Cells Non-Empty Total Counted 3000 2000 2000 1 3 4 1000 1000 1000 2 3 5 1000 0 1 1 2000 3 1 4
Any help would be greatly appreciated!
Bookmarks