View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Get percentage of whole

Thank you, Claus.



On Friday, March 8, 2013 9:22:19 AM UTC-5, Claus Busch wrote:
Hi Susan,



Am Fri, 8 Mar 2013 05:32:15 -0800 (PST) schrieb Susan:



=(SUM($A$3:$E$10000)/(SUM(A3:A10000)))




try:

=SUM(A3:A10000)/SUM($A$3:$E$10000)





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2