Forum Discussion
unexplained error in simple non-contiguous sum function
I have a simple spreadsheet where im trying to total every other cell in a row. for some reason it is not picking up all the cells included in the range. I have made sure formatted as numbers, doub...
I prefer to avoid lists of cells and would either use SUMIFS over the entire row or build each sequence as a distinct array and use SUM.
= SUMIFS(salaries, Item, "T")
= LET(
m, SEQUENCE(1,COUNT(date)/2),
T, INDEX(salaries, 2*m),
SUM(T))