View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hennie[_2_] Hennie[_2_] is offline
external usenet poster
 
Posts: 11
Default Calculate a number for 80% of column

Hi,
I have 2 columns which process days it takes to finalise projects. The 1st
column display the days and the 2nd column display how many projects were
done within this day number:

Days Projects
4 5
12 2 etc.
(400+ projects per month)

Every month the detail is added to the list.

I need to calculate how many days were used for 80% of projects per month.

I use a pivot table to display the list and projects and then do a
calculation next to the pivot table, but this is very time-consuming.
Can you please help me with a function do to this?
Thanks
--
Hennie