LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Total Ashley Excel Worksheet Functions 1 March 31st 07 06:30 PM
running total and average of that total after 3 events belvy123 Excel Discussion (Misc queries) 0 March 28th 07 02:57 AM
running total and average of that total after 3 events Toppers Excel Discussion (Misc queries) 1 March 28th 07 02:19 AM
Running total of hours based on last 7 days Steve Excel Worksheet Functions 1 February 22nd 07 01:40 PM
RUNNING TOTAL LOST IN EXCEL 2000 Excel Worksheet Functions 7 December 27th 05 05:52 AM


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"