Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel 2007 summation by category

05 Mar 2010   #1

Windows 7 Home Premium (64 bit)
Excel 2007 summation by category

I am tracking my budget in Excel because I don't like any of the financial software I have seen... they seem to overcomplicate things. Plus, it is fun to play with.

However, as a beginner, I have an issue... In trying to summarize my "checkbook" sheet, where among other things I have a column of debits, and a colun with a category.

I would like to create a short table that would have the category in one column followed by the amount against that category, year to date (my register only contains transactions year to date.

Something like: sum (column1) only when column2 = xxx

Any ideas? Any good sites that have tips other than beginner stuff? I already KNOW how to create a chart...

My System SpecsSystem Spec

05 Mar 2010   #2

Windows 7 Home Premium (64 bit)

Solution found and modified from another forum.

In column A I have a Category name, in the "Checking sheet, Column E is the category, and D is the dollar amount spent

Formula in column B: =SUMPRODUCT(SUMIF(Checking!E:E,A2,Checking!D:d))

The last D in my formula is actually upper case but colon D = to the forum.
My System SpecsSystem Spec

 Excel 2007 summation by category

Thread Tools

Similar help and support threads for2: Excel 2007 summation by category
Thread Forum
Problems with Excel 2007 Microsoft Office
IE9 and 2007 word and Excel General Discussion
Cannot access the Ribbon functions in Excel 2007 or Word 2007 Microsoft Office
Solved Excel 2007 Addon Microsoft Office
Solved directory xla in Excel 2007 Software
Excel 2007 Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 03:38 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33