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
Little Darwin

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
Little Darwin

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
Thread Forum
Excel 2007 Files Are Now Saving with Fewer KB in Both Excel 2007 and 2
The “problem” I’m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb. I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit. The W700 has Office 2007 and theW541 has Office 2013. Both versions ofExcel are 32 bit as far as I...
Microsoft Office
Excel 2007 (MS Office 2007 enterprise)
I recently formatted my HD and reinstalled MS Office Enterprise 2007, I last used MS Excel on the 08/06/2014 without a problem, today I go to use my Excel spreadsheet and for some weird reason it wants to roundup my cells. I have cleared the cells formatted the number but it still keeps on...
Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
Microsoft Office
Excel 2007
Hi there, I just installed Office 2007, used to have 2003 and now I cannot save my shared files anymore I get an error message when I try to log in stating that an unexpected file protection occured by System Admin. Then when I try to save a file I get an error message saying that I violated...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
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 00:26.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App