Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Sum of values for a month

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SM - 14 Apr 2008 14:37 GMT
Simple query that's probably been asked a million times before so it might
be easier just to point me in the direction of a website that deals with
Excel functions for dimwits.

But my query is this....
I have a simple spreadsheet with the following columns :

Date (A), Description (B), Income (C), Expense (D), Balance (E).

I want a summary of it all at the bottom of the sheet so that for a row
entry of "April 2008" it will look to see all the income entries in April
2008 and total them up. Similarly in the next column on the same row there
should be a total for expenses for April 2008. The next row will be May 2008
etc.

These particular rows will be shoved further down the spreadsheet as more
rows are added with each new entry.

I use the SUMIF function elsewhere but this doesn't apperar to be much use
in this situation.

Thanks.
SM - 14 Apr 2008 15:15 GMT
> Simple query that's probably been asked a million times before so it might
> be easier just to point me in the direction of a website that deals with
[quoted text clipped - 18 lines]
>
> Thanks.

Solved my own problem - just created another column and hid it from view. In
this I used the MONTH function and did the SUMIF on this instead.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.