View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Calculating Percentage of Total

Try

=SUM(A2:A4)/SUM(A2:B4)
Format as %

Mike

"macaskillh" wrote:

Here is what I'm looking for the Total # Sent & Kept for each line. But also
the percentage of # Sent from the total. Does this make sense.

Example: for the first I'm getting 33% sent vs. kept but what percent of the
total were Sent?

# Sent l # Kept
6,843 13,586
30,915 16,418
129,993 19,292