Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Chris wrote...
I am looking to find a way to get Excel to tell me which cells in a given column sum to a given X. For example, the numbers 1, 5, 10, 15, 16, & 20 are in a column. I ask, which of these numbers sums to 36? I am looking for something that responds with e1+f1; a1+a2+a3+f1; a1+d1+f1, etc. From the archives, http://groups.google.com/group/micro...19858047398beb The code in the linked article shows the sums of numbers, but it could be adapted to show cell addresses instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel lookup functions | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions | |||
Excel: Which numbers in a column equal a certain number (withou. | Excel Worksheet Functions |