View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KUNA KUNA is offline
external usenet poster
 
Posts: 2
Default 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.