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 (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
Problems with Excel 2007
Having problems when opening Excel 2007. When I attempt to open I receive a warning from the User Account Control "Do you ant to allow the following program to make changes to your computer?". I normally click yes and it opens up and works fine. However, if I try to open a document that has been...
Microsoft Office
IE9 and 2007 word and Excel
Good Morning Windows 7 Forum, (ignor miss spelling, went to sleep in spelling class) A strange thing has begin to repeat which is this: I click the IE9 LOGO look around the web everything is great. I click the X in the upper right of the window to shut it down, shortly after that a warning...
General Discussion
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 07:16.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App