Adding values from 1 col based on value in diff col
 

I'm trying to do something simple (my opinion) but I'm just not sure how to
do it and the documentation on the functions isn't exactly intuitive or well
done. I have a spreasheet of expenditures. Each row consists of date,
merchant, type (golf, groceries, medical, gas, etc) and amount. I want to
show elsewhere the total of my expenditures by category. This will require a
function will will add column D to the "Gas Expenditures" cell when the value
in column C equals "gas". I'd then do the same with other types of
expenditures. After tackling that, I'll move to the next issue of
maintaining those totals across worksheets (each worksheet representing a
month of the year). If anyone is aware of free unencumbered templates I'd
gladly not reinvent the "wheel". Thanks!

Adding values from 1 col based on value in diff col
 

OK...Just found it. Sorry my bad...should have just searched under SUMIF.
Now to next hurdle...great site.

"Big UT Fan" wrote:

I'm trying to do something simple (my opinion) but I'm just not sure how to
do it and the documentation on the functions isn't exactly intuitive or well
done. I have a spreasheet of expenditures. Each row consists of date,
merchant, type (golf, groceries, medical, gas, etc) and amount. I want to
show elsewhere the total of my expenditures by category. This will require a
function will will add column D to the "Gas Expenditures" cell when the value
in column C equals "gas". I'd then do the same with other types of
expenditures. After tackling that, I'll move to the next issue of
maintaining those totals across worksheets (each worksheet representing a
month of the year). If anyone is aware of free unencumbered templates I'd
gladly not reinvent the "wheel". Thanks!

Adding values from 1 col based on value in diff col
 

=SUMIF(C:C,"Gas",D:D)

if you use the same cell on each sheet, you can sum them like

=SUM(January:December!H1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Big UT Fan" <Big UT wrote in message
...
I'm trying to do something simple (my opinion) but I'm just not sure how
to
do it and the documentation on the functions isn't exactly intuitive or
well
done. I have a spreasheet of expenditures. Each row consists of date,
merchant, type (golf, groceries, medical, gas, etc) and amount. I want to
show elsewhere the total of my expenditures by category. This will
require a
function will will add column D to the "Gas Expenditures" cell when the
value
in column C equals "gas". I'd then do the same with other types of
expenditures. After tackling that, I'll move to the next issue of
maintaining those totals across worksheets (each worksheet representing a
month of the year). If anyone is aware of free unencumbered templates I'd
gladly not reinvent the "wheel". Thanks!