Forum Discussion
Solved
Modified countif ?
Question - what is the method/function to count the number of non-consecutive cells in a ROW, criterion is, if they contain data ? Example - Row has A (date), B (time), C (data), D (time), E (data),...
See Count # of non-consecutive cells in a ROW ?
If the data are numeric:
=COUNT(C2, E2, G2, I2)
If they can be any type:
=COUNTA(C2, E2, G2, I2)
Thank you !