I've been searching for a way to count the number of numeric (only) values within a range of cells who's column number (+ 1) is a multiple of 7 (meaning every 7th column within the range with the first column being "F").
So my base formula would be COUNT(F3:EL162) however I only want the count function to search through every 7th column within that range with F being the first ie. columns F, M,T, AA, AH ... and so on.
Is there a way to do this without me having to use the formula =COUNT(F3:F162)+COUNT(M3:M162)+COUNT(T3:T162)... and so on for another 17 odd column ranges?
By the way the last possible included column for my requirement would be EL. Alternatively the formula could search every 7th column starting with column F - 20 x times (this would finish just before column EL so same result).
Thanks for reading.
Bookmarks