Topic List | Page List: 1 |
---|---|
Topic | Any mediocre excel users on here? Need some help with the sum function... |
Twin3Turbo 05/18/17 12:43:39 PM #7: | Also, if you decide to use his formula =SUM(A1:INDEX(A:A,B1+COLUMN(A1)-1)) I think that you should change it to =SUM(A1:INDEX(A:A,B1+ROW(A1)-1)) But if it were my spreadsheet I would just opt for what I gave you earlier =SUM(A1:INDEX(A:10,B1)) --- ... Copied to Clipboard! |
Topic List | Page List: 1 |