running total based on text

U

ucastores

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!
 
T

Teethless mama

E2: =SUMIF(CriteriaRange,"criteria",SumRange)

F2: =E2/SumRange (format cell as %)
 
U

ucastores

That's what i tried. =sumif(i6:i35,"medicare",i6:i35) and it returned 0.
I'm sorry i wasn't clear. i want it to pick out the number of times medicare
is in the column and give me that number.
 
D

David Biddulph

You need to look again in Excel help to remind yourself of the syntax of the
SUMIF function and what it does. It has done what you asked it to do. You
asked it to add the values in column I in those rows where the value in
column I is equal to the text string "medicare". You are therefore trying
to add up values which are text strings, and of course these evaluate to
zero, so you've got what you asked for.

You may perhaps want COUNTIF instead of SUMIF?
 
U

ucastores

That works well for 3 of the 4 'types' of insurance, but the 4th type is
commercial ins and the text in the column is different for each company. how
can i combine what didn't get counted for the other 3 into one cell? i
looked at countif with wild cards but there are too many different names and
lengths of the names. Any help is appreciated.
 
D

David Biddulph

Is it as simple as counting the total and then subtracting the sum of the
other categories?
 
U

ucastores

I finally figured out how to do exactly that. I'm a novice so sumif's and
countif's are new to me, but i came up with a countif with a wild card to sum
the total of the column. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to make a running total for three different items 1
Consolidation Table from Different Excel Tabs with Different Format 1
Main history of car insurance 0
Excel PMT Function Help 2
SUMPRODUCT except for 7
Word 2016 - Difficulties Learning Style Creation/Application 0
Best Practices (Counter) 3
Summing one column based on criteria from two other columns 2

Top