Forum Discussion

User537843's avatar
User537843
Copper Contributor
Jun 07, 2023

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...
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jun 08, 2023

User537843 

My guess is that you do not have Excel 365?  Otherwise the main disruption to the formula I provided is not that the stride length between answers is now 5, it is that you want the results to be a horizontal list rather than vertical.

= LET(
      colorArr, TAKE(WRAPROWS(ColorRng, 5),, 1),
      matches,  IF(colorArr={"Red","Green"}, 1),
      BYCOL(matches, SumĪ»)
  )

Resources