Forum Discussion
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...
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.
I 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")
=countifs($1:$1,"<>", $21:$21, "Red")
=countifs($1:$1,"<>", $21:$21, "Green")