I suspect what I want to do is fairly easy, but I need help
nonetheless.
I have a workbook I'm using to track expenses for a project. On each
worksheet, I have bank statements with transaction amounts. I have
gone through and labelled each of these transaction amounts with a tax
reference (e.g., "Maintenance"). So, on a worksheet, there might be
three Maintenance cells, with the neighbouring cell representing the
transcation's value. I know how to define a Name to get a constant
value (e.g., A2's value is Tax, A3's value is the current tax rate, so
I just define "Tax" then on another cell I can multiply 10*tax to find
out how much tax I pay on $10).
I would like to do something similar, but here I just want to add up
all the cells with a neighbouring name/label of "Maintenance" I
suspect I can do this with name, but can't figure it out. Can someone
show me how to do this?

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mikeg" wrote in message
...
I suspect what I want to do is fairly easy, but I need help
nonetheless.
I have a workbook I'm using to track expenses for a project. On each
worksheet, I have bank statements with transaction amounts. I have
gone through and labelled each of these transaction amounts with a tax
reference (e.g., "Maintenance"). So, on a worksheet, there might be
three Maintenance cells, with the neighbouring cell representing the
transcation's value. I know how to define a Name to get a constant
value (e.g., A2's value is Tax, A3's value is the current tax rate, so
I just define "Tax" then on another cell I can multiply 10*tax to find
out how much tax I pay on $10).
I would like to do something similar, but here I just want to add up
all the cells with a neighbouring name/label of "Maintenance" I
suspect I can do this with name, but can't figure it out. Can someone
show me how to do this?

Assume your tax reference is in column A and the values are in column B.
At the bottom of column B data, put this formula

=SUMIF(A2:A6,"Maintenance",B2:B6)

You would need to adjust the range to the actual length.

"mikeg" wrote in message
...
I suspect what I want to do is fairly easy, but I need help
nonetheless.
I have a workbook I'm using to track expenses for a project. On each
worksheet, I have bank statements with transaction amounts. I have
gone through and labelled each of these transaction amounts with a tax
reference (e.g., "Maintenance"). So, on a worksheet, there might be
three Maintenance cells, with the neighbouring cell representing the
transcation's value. I know how to define a Name to get a constant
value (e.g., A2's value is Tax, A3's value is the current tax rate, so
I just define "Tax" then on another cell I can multiply 10*tax to find
out how much tax I pay on $10).
I would like to do something similar, but here I just want to add up
all the cells with a neighbouring name/label of "Maintenance" I
suspect I can do this with name, but can't figure it out. Can someone
show me how to do this?

Look at help for the SUMIF() worksheet function. If I understand your post
correctly, the actual entries in the tax references are like "Maintenance"?
And if so, then SUMIF() should work for you.


"mikeg" wrote:

I suspect what I want to do is fairly easy, but I need help
nonetheless.
I have a workbook I'm using to track expenses for a project. On each
worksheet, I have bank statements with transaction amounts. I have
gone through and labelled each of these transaction amounts with a tax
reference (e.g., "Maintenance"). So, on a worksheet, there might be
three Maintenance cells, with the neighbouring cell representing the
transcation's value. I know how to define a Name to get a constant
value (e.g., A2's value is Tax, A3's value is the current tax rate, so
I just define "Tax" then on another cell I can multiply 10*tax to find
out how much tax I pay on $10).
I would like to do something similar, but here I just want to add up
all the cells with a neighbouring name/label of "Maintenance" I
suspect I can do this with name, but can't figure it out. Can someone
show me how to do this?
.

SUMIF is exactly what I was looking for. I got what I wanted with:
=SUMIF(E1:E67,"=Maintenance",F1:F67)

Thanks so much for your assistance!

On Apr 11, 1:20*pm, JLatham wrote:
Look at help for the SUMIF() worksheet function. *If I understand your post
correctly, the actual entries in the tax references are like "Maintenance"? *
And if so, then SUMIF() should work for you.



"mikeg" wrote:
I suspect what I want to do is fairly easy, but I need help
nonetheless.
I have a workbook I'm using to track expenses for a project. On each
worksheet, I have bank statements with transaction amounts. I have
gone through and labelled each of these transaction amounts with a tax
reference (e.g., "Maintenance"). So, on a worksheet, there might be
three Maintenance cells, with the neighbouring cell representing the
transcation's value. I know how to define a Name to get a constant
value (e.g., A2's value is Tax, A3's value is the current tax rate, so
I just define "Tax" then on another cell I can multiply 10*tax to find
out how much tax I pay on $10).
I would like to do something similar, but here I just want to add up
all the cells with a neighbouring name/label of "Maintenance" I
suspect I can do this with name, but can't figure it out. Can someone
show me how to do this?
.- Hide quoted text -

- Show quoted text -