| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What cells in a array equal my value?
Hi all.
I have a column of cells that have many different values. These values are numerical costs. ie 150.54, 5,541.00 ect I have a numerical value that comprises of several of these cells added together. However I do not know which ones need to be added to get the value I'm looking for... Is there a function I can use that will take all the cells and advise which ones need to be added to equal my value? I think this might be a tough one.. Many thanks in advance Stephen. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
| Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
| check if 2 cells are equal but only if they contain numbers not i. | Excel Worksheet Functions | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Threaded Mode
