View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ucastores ucastores is offline
external usenet poster
 
Posts: 17
Default running total based on text

i have a column that i type in insurances.
i have four different broad types of insurances, medicare, medicaid, self
pay, and commercial insurance. The commercial insurance is listed by the
specific company.
I want to do a running total of each type and place the total in a separate
cell (each type would have its own cell). Then I need to know what percent
of each type is of the total of all types. i.e. medicare is 30% of all the
different types of insurance.

I tried Sumif and that didn't work

Help please!