EXCEL FIND A SPECIFIC TOTAL
Is there a formula or look up function within excel that will do the following:
Locate within a range of cells the cells that when summed together equal a
specified amount.
For example: I am looking for 22,000 amount that is a combination of the
records within a range of cells.
Will excel show me the possible results even if it were many?
Help and thanks.
|