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's hard to visualize exactly what you're talking about.
This will probably work for you; give it a try:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Post back if it doesn't work for you...

Regards,
Ryan--


--
RyGuy


"LisaK" wrote:

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.

"ryguy7272" wrote:

It's hard to visualize exactly what you're talking about.
This will probably work for you; give it a try:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Post back if it doesn't work for you...

Regards,
Ryan--


--
RyGuy


"LisaK" wrote:

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

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:B 5)))

Regards,
Ryan--

--
RyGuy


"LisaK" wrote:

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.

"ryguy7272" wrote:

It's hard to visualize exactly what you're talking about.
This will probably work for you; give it a try:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Post back if it doesn't work for you...

Regards,
Ryan--


--
RyGuy


"LisaK" wrote:

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

Try Pivot Table.
No formulas needed.
http://www.freefilehosting.net/download/3a6eh

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

--

Regards
Roger Govier

"LisaK" wrote in message
...
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