LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate and display the number of values in a column control engineer Excel Discussion (Misc queries) 2 April 9th 07 08:02 PM
how to calculate the number of non blank cells from any column? Mahesh Excel Worksheet Functions 2 August 8th 06 01:14 PM
How do I Calculate Percentages for each number in a column? Dena B Excel Discussion (Misc queries) 5 August 10th 05 08:46 PM
Calculate number of days in a column of dates Barbara Excel Discussion (Misc queries) 3 May 25th 05 04:21 PM
Calculate number of days in a column of dates Barbara Excel Discussion (Misc queries) 8 May 25th 05 02:48 PM


All times are GMT +1. The time now is 11:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"