Forum Discussion
Solved
Help on Error message "There's a problem with this formula"
Hi, I am looking for help to resolve this error message: I am trying to put in a spilled formula for the years 2025 - 2028 to sum by years. I knew the current highlighted formu...
If without exotic and use the same formula
=LET( months, $BK$1:$BS$1, years, $BE$1:$BI$1, data, $BK$3:$BS$6, n, SEQUENCE( ROWS(data) ), sums, LAMBDA(v, MMULT(v, --(TRANSPOSE(YEAR(months)) = years) ) ), raw, REDUCE(0, n, LAMBDA(a,i, VSTACK(a, sums(CHOOSEROWS(data,i))) ) ), DROP(raw,1) )
The criteria range must be a cell reference. No formulas. No operations.
Hi, Lewin:
Do you mean YEAR(...) cause issue? Thanks,
Do you mean YEAR(...) cause issue? Thanks,
- Any suggestions of new formula which would work? Thanks, appreciated!
=SUMIFS(BK3:BS3,BK2:BS2,BF1)