Forum Discussion
Equation Question
The following is a formula that I have in my spreadsheet: =-SUM(SUMIF(INDIRECT({"k2","k7","k11","k15","k19","k23","k27","k31","k35","k39","k43","k47","k51","k55"}),">0")) I would like to drag, o...
If you use SUMPRODUCT() instead of SUMIF(), it should work:
=LET(in,VSTACK(K2,K7,K11,K15,K19,K23,K27,K31,K35,K39,K43,K47,K51,K55),-SUMPRODUCT(in,--(in>0)))