Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I sum numbers thru specifying the amount from another cell?
So this is what I was wondering on how to do:
I have a set of numbers, and I want to sum them, BUT I don't always want to sum all of them. The amount to sum is specified thru another cell, and I am always summing the numbers in order. Ex. if I type in a cell "5", it'll sum the first 5 numbers, but if i type in 10, it'll sum the first 10 numbers. So basically, the numnbers to sum are dependent on the number you input in the one cell. I tried looking at SUMIF, but that only returns the sum if the corresponding row of another column meets a criteria. The criteria for my case is in the one cell. What equation do I use? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to limit amount of numbers in cells in excel | Excel Worksheet Functions | |||
For Hector Miguel - Inserting page numbers in cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |