Hello,
I am trying to figure a formula that will count a specific number of cells, but the amount of cells I want to count will vary as the formula is dragged down. I attached an example.
I need a formula to count the number of cells with values in it per participant. For example, the formula should show "3" for participant 1, "3" for participant 2, and "1" for participant 3.
I have a large amount of data, so this would be very helpful.
Thanks,
B
Bookmarks