Count all numeric values in a range but only every 7th column

[JR73]

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.

[XLent]

one option

=SUMPRODUCT(ISNUMBER($F$3:$EL$162)*(MOD(COLUMN($F$3:$EL$162)-COLUMN($F3),7)=0))

[JR73]

Worked a treat! Thank you very much.

[JR73]

I hope this didn't require a new thread but...
If I wanted to know how many of the numeric values from above result were the number 0?
Using my late night logic I have tried (unsuccessfully): =SUMPRODUCT(COUNTIF(Data!$F$3:$EL$162,"=0")*(MOD(COLUMN(Data!$F$3:$EL$162)-COLUMN(Data!$F3),7)=0))
(sheet is called "Data" which I didn't mention in previous post)

[ChemistB]

You were close. You don't need the countif inside the SUMPRODUCT and you will still need the ISNUMBER if you have blank cells as they will return TRUE for cell=0. So

Please Login or Register  to view this content.

Does that work?

[JR73]

The result is about what I would expect (without actually counting through all the data) so I'm going to say yes.
Thanks very much to you too!

[Pepe Le Mokko]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.