View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
external usenet poster
 
Posts: 447
Default Formula help needed

I have a chart with 5 columns :

Month | Section | Area | Time
Jan | 1 | A | 00:30
Jan | 3 | B | 01:30
Feb | 2 | A | 00:30
Feb | 1 | B | 01:30

Need to find out the total time based on different month, Section, Area.
That is, if I want the total time for Jan in Section 3, Area B what formula
can I use?

Thank you.