Need Correct Function

N

Nick

Hello..

I have a spreadsheet in Excel 2003.

Column A
Mortgage
Taxes
Utilty
Mortgage
Utility (so on and so forth)

Column B
$1000
$2200
$100
$1000
$100

What I am trying to do is get a "grand total" based on the value in column
A. Basically, I am hoping that the function can go through column A,
identify each "mortgage" entry (for example) and then get the amount spent
from column B and give me a grand total. In this case, I would get $2000.

Any help would be appreciated!
 
L

Luke M

Take a look at SUMIF in help file

=SUMIF(A:A,"Mortgage",B:B)

If you were creating a report, a handy thing would be to have the report
have a unique list of all possible entries, and then change "Mortgage" in
your formula to a cell reference, making it easier to copy formula for other
uses.
 
N

Nick

Thank you!

Luke M said:
Take a look at SUMIF in help file

=SUMIF(A:A,"Mortgage",B:B)

If you were creating a report, a handy thing would be to have the report
have a unique list of all possible entries, and then change "Mortgage" in
your formula to a cell reference, making it easier to copy formula for other
uses.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 
N

Nick

Thank you!

Luke M said:
Take a look at SUMIF in help file

=SUMIF(A:A,"Mortgage",B:B)

If you were creating a report, a handy thing would be to have the report
have a unique list of all possible entries, and then change "Mortgage" in
your formula to a cell reference, making it easier to copy formula for other
uses.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 

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

Top