# Count if Every 5th Cell in column is a zero

1. ## Count if Every 5th Cell in column is a zero

Hi,

I need to count every 5th column in a row (down for 1500 rows) if the value of that 5th column is a zero.....

Also, whilst Im here I was possibly looking at creating a new table of each value of every 5th row so it strips out all the ones in between (down for 1500 rows). Any idea how that might be done?

Thanks

2. ## Re: Count if Every 5th Cell in column is a zero

Please try =SUM((MOD(COLUMN(\$F1:\$Z1),5)=0)*(F1:Z1=0))
See also https://www.excelforum.com/excel-for...ml#post5752637

3. ## Re: Count if Every 5th Cell in column is a zero

Cell AB1 formula

Formula:
`Please Login or Register  to view this content.`

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1