Running Sum question

  • Thread starter Thread starter LisaK
  • Start date Start date
L

LisaK

Here is an example of my spreadsheet:

Review Reason #claims
BAIR 10
BAMB 15
BDMS 6

The BAIR reason can show up on a couple of different reports. I want to be
able to have a running total in # claims column so that I do not have to
manually add to that number. Is there any formula that will do that?

Thanks.
Lisa
 
It doesn't look like that will work. Let's take the review reason BAIR for
example. I have a paper report that we enter data into an excel spreadsheet
from. For location 40 BAIR can show up and have 10 claims and then for
location 65 BAIR can have 6 claims. I want to take 10 +6 and have it
manually add into one cell. The data is coming from a paper report. So I
can't reference cells. Does that make sense. It's very hard to explain.
 
Hummm, just feeling a little baffled... I think this will help:
A1:A2=
40 BAIR
65 BAIR

B1:B2=
10
6

Use this:
=SUMIF(A1:A2,"*BAIR",B1:B2)

or this:
=SUMPRODUCT(ISNUMBER(SEARCH("*BAIR",A1:A5))*((B1:B5)))

Regards,
Ryan--
 
Hi Lisa

Assuming the names BLAIR etc are in column A and #Claims is in column B

Enter the name you want in C1
in D1 enter
=SUMIF(A:A,C1,B:B)

Enter the other names you want in C2, C3 etc and copy the formula down as
far as required
 
Back
Top