Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add a range of numbers to sum a specific total?
How do I add numbers from a range of numbers (selecting only certain in that
range) to come up with a specific total? |
#2
|
|||
|
|||
=SUMIF(A1:A100,"value")
-- HTH RP (remove nothere from the email address if mailing direct) "SJoshi" wrote in message ... How do I add numbers from a range of numbers (selecting only certain in that range) to come up with a specific total? |
#3
|
|||
|
|||
For a possible solution see
http://tinyurl.com/4doog -- Regards, Peo Sjoblom "SJoshi" wrote in message ... How do I add numbers from a range of numbers (selecting only certain in that range) to come up with a specific total? |
#4
|
|||
|
|||
You may also want to check
Find a set of amounts that match a target value http://www.tushar-mehta.com/excel/ti...set-match.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... How do I add numbers from a range of numbers (selecting only certain in that range) to come up with a specific total? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
find numbers in a range that add to a specific value | Excel Discussion (Misc queries) | |||
How do I reference and sort a range of numbers in Excel 97? | Excel Worksheet Functions |