MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formula


Posted by Scott Dacey on January 21, 2002 6:22 PM

I am in the consulting business and I bill my cleints at the beginning of each month based upon the work my employees and I have billed during the previous month--typically calculated at quarter hour increments. Within the billing statement I have a cell that reads:(12.5 hours @$50 per hour). I would like to have the number of hours--in this case 12.5-- pulled from another worksheet that totals up hours from a number of employees working for that particular client. How can I do this? Thank you.


Posted by Barrie Davidson on January 21, 2002 6:26 PM

Something like this will work:

="("&TEXT(SUM([Book1]Sheet1!$A$1:$A$14),"#,##0.00")&" hours @ $50 per hour)"

Hope this helps you out.
BarrieBarrie Davidson

Posted by Barrie Davidson on January 21, 2002 6:27 PM

Make that....

="("&TEXT(SUM([Book1.xls]Sheet1!$A$1:$A$14),"#,##0.00")&" hours @ $50 per hour)"

Barrie Davidson