Hi. I have several columns labeled "Monitoring Visit 1...Monitoring
Visit 8", but interspersed between them I have columns labeled "Report
Date", with each report being associated with a given Monitoring visit.
In the last column, on each row, I want to count the number of cells
with dates in them, which signifies if a monitoring visit has occurred
or not. I can't do a normal count if, because of the extra Report
columns in between, which have stay where they are. Can anyone lead me
to the right formula? Thanks.