View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DB74 DB74 is offline
external usenet poster
 
Posts: 20
Default Addition function of multiple cells

Does anyone know if there is a function that will take a list of numbers in
different cells and run various addition combinations on the list to detemine
which cells will add to a specific number? For example:

A1 = 1
A2 = 2
A3 = 5
A4 = 7

I want to know which cells added to gether will give me 6...answer = A1 + A3