View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Data Summary Automation Help!!!

I'm sorry I don't follow what add a c d means? And I don't follow what you
are SUMming? And what does YTD mean - all projects that have started or
finished or something else?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Greg" wrote:

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