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!