Excel Formula Question

  • Thread starter Thread starter pantherguy
  • Start date Start date
P

pantherguy

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.
 
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)
 
Back
Top