Forum Discussion
User537843
Jun 07, 2023Copper Contributor
Dem Apples
I have a large warehouse of apples. I am counting each apple by its color in every other cell. I need to ignore all data inbetween each cell, that data will not be counted. The list of apples w...
mtarler
Jun 07, 2023Silver Contributor
Option 1 based on headers in Row 1
=countifs($1:$1,"<>", $3:$3, $A5)
Option 2 based on columns being ODD numbered
=SUMPRODUCT(MOD(COLUMN($3:$3),2)*($3:$3 =$A5))
- User537843Jun 08, 2023Copper Contributor
Thank you, I have changed my spreadsheet somewhat. How could I count the hundreds of apples by color using this sheet? I tried modifying your formula, mtarler, but I failed. Thank you.
- mtarlerJun 13, 2023Silver ContributorI don't know if you solved this but based on your image here are the modified formulas:
=countifs($1:$1,"<>", $21:$21, "Red")
=countifs($1:$1,"<>", $21:$21, "Green")