column count error

[Ronderbecke]

Currently, I am trying to count all the fields that have a date (some have links inserted to them and some don't) and I am getting an error message. My formula is:

=SUMPRODUCT(--(MOD(COLUMN(H12:FB)-COLUMN(H12),7)=0),--(LEN(H12:FB)>0),ISTEXT(H12:FB)+ISNUMBER(H12:FB))

the error it's giving me is this:

ErrorSUMPRODUCT has mismatched range sizes. Expected row count: 1. column count: 151. Actual row count: 989, column count: 151.

Is there a way to count every nth column but counting the full row as well? It looks like it wants me to simply count only 1 row?

 

[mole999]

is this something you normally do

COLUMN(H12:FB) to me thats a range of sorts

COLUMN(H:FB) would be columns

not sur where the claifier for FB exists (or is that hust me)

 

[Ronderbecke]

is this something you normally do

COLUMN(H12:FB) to me thats a range of sorts

COLUMN(H:FB) would be columns

not sur where the claifier for FB exists (or is that hust me)

Yes, the reason you have the 12 on the H12 is because it needs to start at row 12 and count down from there. There is no range set for FB because I want it to continue counting all rows continuously. That way if there are 40 rows it counts to H52 and if there are 60 it goes to H72 and so on. Does that make sense? This is done in google sheets which is why you are able to have no end point.