Remember Me?

#1
June 11th 09, 11:16 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2009 Posts: 25
Give me a Function

Dear Friends

Project Space %
59033 685 9.4%
59242 294 4.0%
58578 409.7 5.6%
61861 409.7 5.6%
62192 351.4 4.8%
62571 351.4 4.8%
TOTAL 7309 100%
This is the projects we are currently runing. some of our over head costs
are attributed to the project based on space. we have now closed one project
say 58578(project no) we want to allocate the space used by 58578 to all
other remaing project based on the percentage that is all other project share
the cost. please provide me a way. thanks
note that for simplysity i have deleded lot of project so total does not
match as it shows

#2
June 11th 09, 01:09 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 2,276
Give me a Function

Hi,
7309 is the total to be distributed, so have it at the top of your columns
let's say cell A1, in cell B1 you have the subtotal of all the projects so
the formula will be
=subtotal(9,B2:B1000)

Then in cell D2 enter

=C1/\$B\$1*\$A\$1

Copy the formula down

if this helps please click yes, thanks

"Fareez" wrote:

Dear Friends

Project Space %
59033 685 9.4%
59242 294 4.0%
58578 409.7 5.6%
61861 409.7 5.6%
62192 351.4 4.8%
62571 351.4 4.8%
TOTAL 7309 100%
This is the projects we are currently runing. some of our over head costs
are attributed to the project based on space. we have now closed one project
say 58578(project no) we want to allocate the space used by 58578 to all
other remaing project based on the percentage that is all other project share
the cost. please provide me a way. thanks
note that for simplysity i have deleded lot of project so total does not
match as it shows

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Josh Craig Excel Worksheet Functions 5 April 2nd 09 03:45 AM force530 Excel Worksheet Functions 3 September 22nd 06 12:03 AM pmartin Excel Worksheet Functions 2 July 6th 06 06:08 PM Jay Excel Worksheet Functions 7 June 25th 06 09:08 PM Calaw Excel Worksheet Functions 8 November 11th 05 10:48 AM

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