Counting non blank values every 7th row

[guibro]

Hi Excel Users,

I'm looking for a formula that can count if a date has been put in the cell every 7th row but only those rows. I guess it cannot be a sum because the format will be a date.

I've already tried those formulas but it didn't work so far: (It is just few examples of what I've tried, they might not be right... )

=COUNT(IF(AND(MOD(ROW($C$8:$C$507),7)=0,ISBLANK(MOD(ROW($C$8:$C$507),7)=FALSE)),$C$8:$C$507,0))

=SUM(COUNTA(INDIRECT(ADDRESS(7*ROW(1:1000)+3,COL(C8)))))

=SUMPRODUCT(--(MOD(ROW(C8:C804),7)=0),--(C8:C804<>""))

The reason for that is because I'm looking to evaluate the performance of each step and see how many times does the step have been completed.


You can refer to the excel file, I'm looking to count for each Milestone, how many times the step has been completed by association with the date next to it, and that for the entire sheet.

Thank you very much for your help.

work template 2.xlsx

[bebo021999]

Which values do your expect to have in A9, A16 and A23?

[guibro]

None Actually.

I already have a formula (that I did not put in this sheet) which is automatically adding the partner name on A7, A14, A21, so on and so forth, from a partner contact sheet.

So the other cells in the column A besides the multiples of 7 are empty.

[bebo021999]

It is still unclear (for me , at least)

Do you want to count for each milestones, for instant, "SALT-in-a-Box sign up", with a date next to it, and the result should be 2?
Or do you want to count them all with dates next to them, and results should be 5?

[protonLeah]

I don't understand where your count starts but try, in Q2:

Please Login or Register  to view this content.

[guibro]

I want to be able to tell how many "SALT In the box sign up" has been filed with a date next to it.

So far example, I have a date in 2 "salt in a box sign up". So it would be your first option.

Please tell me if you need more information. thank you for your help on this.

[protonLeah]

Please Login or Register  to view this content.

[guibro]

Thanks B Johson but can you provide a little bit more details please.

I want to be able to repeat this formula for each Milestone ( I have 5 milestones) and see how many of them has been associated with a date next to it.

Once again thanks, but I guess I can't locate in the formula where does the Mod(Row part refers to...

[guibro]

Thanks ! this is perfect !