kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
Hello Everyone,
I have a challenge here with me:
I have headers x y z. They keep repeating at regular intervals; x y z x y z etc. Now I want to count based on each header the number of cells that contain values greater than 0. I tried to use the countif but did not do what I wanted. I am thinking of matching the headers but can't seem to figure it out. Help me pull it up. Thanks in advance.
Kelly
PS. These cells are filled with formulas
I have a challenge here with me:
I have headers x y z. They keep repeating at regular intervals; x y z x y z etc. Now I want to count based on each header the number of cells that contain values greater than 0. I tried to use the countif but did not do what I wanted. I am thinking of matching the headers but can't seem to figure it out. Help me pull it up. Thanks in advance.
Kelly
PS. These cells are filled with formulas
Last edited: