Thread: Calculating cumulative percentage
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Calculating cumulative percentage
In B1:
=SUM(A$1:A1)/SUM(A:A)
Format B1 as percentage, copy down.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Prospect" wrote:
oh, of course!
Now I'm curious...what if I hadn't already calculated each percentage and
only wanted the cumulative figure?
--
David
Reply With QuoteReply With Quote