jeudi 17 mai 2018

Skipping cells in IF/CountIf

I made this formula:
=IF(COUNTIF(D5:D8,">0")<>H5,"Yes","No")

It works fine, but I need the CountIf to skip 5 cells whenever I drag it down. So D5:D8 would be D10:D13 the next cell, then D15:D18 and so on. I can't figure out how to do this and I really don't want to manually change 170+ cells.
If anyone could help I would really appreciate it.

Aucun commentaire:

Enregistrer un commentaire