Excel Formula Question
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. |
Excel Formula Question
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. |
Excel Formula Question
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. |
Excel Formula Question
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. |
All times are GMT +1. The time now is 01:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com