Count number of rows with data

Hello,

I'm trying to figure out how to count the number of rows that contain data.

I have 4 columns and numerous rows. Each column represents a class. Each row represents a participant. I want to know how many unique participants we've had in the classes. I'm assuming SumProduct would work, but I can't figure out how to formulate it.

In the table below, we have 4 potential participants, but only 3 of them have come to class. 3 is the number I'm looking for.

Names Date Date Date Date
Participant 1 1/20/2018 2/14/2018
Participant 2 2/14/2018
Participant 3
Participant 4 1/20/2018

Assuming that your dates are in B2:C5, try this:

=SUMPRODUCT(--(SUBTOTAL(9,OFFSET(B2:C2,ROW(B2:C5)-ROW(B2),,1))>0))

If your first Date column is B, then you could try this:

=COUNT(B:B)

Hope this helps.

Pete

I like to be complicated. Both actually work and are helpful. The more complex formula is what I was looking for. However, due to the formula I was using to pull the dates, the 1st column would be the first to have any value so it wasn't necessary. I'm adding it to my list though just in case I ever need it again.