View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikki72 Nikki72 is offline
external usenet poster
 
Posts: 1
Default Why formula should I use?

I would like to create summary worksheet summing data from another sheet.

Here's sample

........a..............b............c............. d
1....client.......fund......amount......date
2......abc..........1...........$20..........1/08
3......xyz...........2...........$40..........2/08
4......abc..........1............$50..........3/08
5......def..........2............$10...........4/08

I want to create a new summary worksheet to sum total dollars by date and
underlying fund.

Not sure what formulas I should be using?

Any help?