That you need to do this is kind of an indication of bad spreadsheet design ...
=SUMPRODUCT( (MOD(COLUMN(I2:IV2) - COLUMN(I2), 2) = 0 ) * (I2:IV2 <> "") )
That you need to do this is kind of an indication of bad spreadsheet design ...
=SUMPRODUCT( (MOD(COLUMN(I2:IV2) - COLUMN(I2), 2) = 0 ) * (I2:IV2 <> "") )
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks