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