Running Sum question

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
 
L

LisaK

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.
 
R

ryguy7272

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--
 
R

Roger Govier

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
 
Top