I'm not sure how many Excel experts are out there, but I've got a question
for you. I'm creating a worksheet for a budget (New Year's resolution) and I
want to enter in a formula to add up the totals for a given category. For
example, I have categories in column B (gas, clothes, groceries, etc.) and
the amount in column D. What I would like to do is have a seperate column
that adds up all of the totals in the category of groceries and the total in
clothes. I'm assuming this would be like the IF statements, but I'm really
bad at using formulas in Excel. If you know the answer or could point me to a
place that would have it, I would greatly appreciate it. Thanks.

This will take just a tad bit of work on your part, but it should be pretty
easy:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Regards,
Ryan---

--
RyGuy


"pantherguy" wrote:

I'm not sure how many Excel experts are out there, but I've got a question
for you. I'm creating a worksheet for a budget (New Year's resolution) and I
want to enter in a formula to add up the totals for a given category. For
example, I have categories in column B (gas, clothes, groceries, etc.) and
the amount in column D. What I would like to do is have a seperate column
that adds up all of the totals in the category of groceries and the total in
clothes. I'm assuming this would be like the IF statements, but I'm really
bad at using formulas in Excel. If you know the answer or could point me to a
place that would have it, I would greatly appreciate it. Thanks.

Thanks ryguy, I used the =SUMIF function and thanks to the help menu, got it
figured out. I guess I was using the wrong range before. Thanks for all the
help.

"ryguy7272" wrote:

This will take just a tad bit of work on your part, but it should be pretty
easy:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Regards,
Ryan---

--
RyGuy


"pantherguy" wrote:

I'm not sure how many Excel experts are out there, but I've got a question
for you. I'm creating a worksheet for a budget (New Year's resolution) and I
want to enter in a formula to add up the totals for a given category. For
example, I have categories in column B (gas, clothes, groceries, etc.) and
the amount in column D. What I would like to do is have a seperate column
that adds up all of the totals in the category of groceries and the total in
clothes. I'm assuming this would be like the IF statements, but I'm really
bad at using formulas in Excel. If you know the answer or could point me to a
place that would have it, I would greatly appreciate it. Thanks.

Hi

With Groceries in E1 and Clothes in E2, enter in F1
=SUMPRODUCT(($B$2:$B$1000=E1)*$D$2:$D$1000)
Copy down to F2

Change the ranges to suit - I have chosen 1000 rows. Make the range
sufficient to cover your entire set of data. Ensure both ranges are of equal
dimension.
You cannot use whole columns as ranges (except in XL2007)

--

Regards
Roger Govier

"pantherguy" wrote in message
...
I'm not sure how many Excel experts are out there, but I've got a question
for you. I'm creating a worksheet for a budget (New Year's resolution) and
I
want to enter in a formula to add up the totals for a given category. For
example, I have categories in column B (gas, clothes, groceries, etc.) and
the amount in column D. What I would like to do is have a seperate column
that adds up all of the totals in the category of groceries and the total
in
clothes. I'm assuming this would be like the IF statements, but I'm really
bad at using formulas in Excel. If you know the answer or could point me
to a
place that would have it, I would greatly appreciate it. Thanks.