Count if Every 5th Cell in column is a zero

**Barking_Mad** · 11-11-2022, 07:12 AM

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

**HansDouwe** · 11-11-2022, 07:37 AM

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

**wk9128** · 11-11-2022, 08:00 AM

Cell AB1 formula

Formula:

Please Login or Register  to view this content.

Count if Every 5th Cell in column is a zero

LinkBack

Thread Tools

Rate This Thread

Display

Count if Every 5th Cell in column is a zero

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] count up in Column A until the next non-blank cell in Column C

[solved]Count if cell from one column is equal to cell in other column

Count: number of cell values in each unique column sub_class expressed by column class

Count column value then adjacent column cell fill color

Column Cell Count with variable in column marker, Type mismatch

Trying to count unique values for one column when another column is equal to a cell

Count Column A only up to last nonblank cell in Column B

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions