Forum Discussion
Solved
Count odd or even cells that have a date value
Hello, I would like to count the dates in a column but only in the odd or even cells. More details (see also image) : it's a column having predicted and actual dates. Only the cells that have a ...
As variant
=SUMPRODUCT( ISEVEN(ROW($B$2:$B$13 ))*ISNUMBER($B$2:$B$13) ) =SUMPRODUCT( ISODD(ROW($B$2:$B$13 ))*ISNUMBER($B$2:$B$13) )
As variant
=SUMPRODUCT( ISEVEN(ROW($B$2:$B$13 ))*ISNUMBER($B$2:$B$13) )
=SUMPRODUCT( ISODD(ROW($B$2:$B$13 ))*ISNUMBER($B$2:$B$13) )- Brilliant! This works also for the full file in my reply above.
Thanks!Bourrinho , you are welcome
