Is there some kind of formula that can sum an amount or rows based on a number you type in? Like if for example, I want to sum only 50 rows one time, 300 another, 1000 yet another and so on is there some way I can do this without having to highlight different sections to see totals? Ideally if I could just type in 50 and it sums the first 50 rows in a specified column and then the same for any other number that is typed in. It would always start from the top.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sum number of rows
- Thread starter bh24524
- Start date
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Similar threads
- Question
- Question
- Solved
- Solved
