View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Gans Ray Gans is offline
external usenet poster
 
Posts: 1
Default How to lookup and sum multiple values based on multple columns

I would like to have one table with the names of people with an amount of
money owed combined with the length of time it has been owed. So something
like:

Name 0-15 16-30 30+
Bill 12.75 0 32.16
Steve 0 5 75.25

And another table with the name of a person an amount of money owed and the
date that it is owed from. So something like:

Name Date Fee
Bill 2/3/04 32.16
Steve 5/4/05 50
Steve 6/28/05 25.25
Steve 7/8/05 5
Bill 7/28/05 8.75
Bill 8/1/05 4

I would like for the first chart to be able to look up the data from the
second chart and add it up and place it in the appropriate row under the
correct range of dates.

Thanks,
Ray