View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greg Greg is offline
external usenet poster
 
Posts: 331
Default Data Summary Automation Help!!!

Hi,
Hi can someone help me automate a summary of the following:

Phase Added a c d
Finish
COMPLETED 10/16/08 1 10/16/08
COMPLETED 11/20/08 1 11/20/08
COMPLETED 04/24/09 1 06/06/08
EXECUTION 01/05/09 1 01/05/09
EVALUATION 03/19/09 1 05/01/09
QUALIFICATION 07/30/09 1 09/01/09

I'm trying to summary so it looks like:

inactive qualification evaluation execution completed Total MTD Total YTD
a sum sum etc....
b
c

I should be able to automat this with a few foermulas. PLEASE HELP!!
Thanks,
Greg