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...
Exploiting 365 functionality allows one to select alternate values from the range 'colorRng' by wrapping the data to 2 rows and selecting the first.
= LET(
colorArr, TAKE(WRAPCOLS(colorRng, 2), 1),
matches, IF(colorArr={"Red";"Green"}, 1),
BYROW(matches, SumĪ»)
)
where SumĪ»
= LAMBDA(x, SUM(x))