Forum Discussion
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), F (time), G (data),H (time), I (data).
Data (readings) can be randomly entered up to 4 times a day - so (currently) Col J is manually completed with the number of data entries in cells C, E, G, and I, needs automation.
COUNTIF requires a range. Non-consecutive cells are not a range, so what's the solution, please?
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)
2 Replies
Thank you !
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)
