 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006SUM by month
i have the following case: DATE Ammount 01.12.06 50 05.12.06 100 12.12.06 200 25.12.06 240 01.01.07 200 15.01.07 210 27.01.07 111 etc... I would like to SUM the ammounts by month month ammount dec. 06 590 jan. 07 521 how do I do that? thanks! =SUMPRODUCT(--(YEAR(A2:A8)=2006),--(MONTH(A2:A8)=12),B2:B8)  SignatureHTH Bob (change the xxxx to gmail if mailing direct) >i have the following case: > [quoted text clipped - 17 lines] > > thanks! |
Reply to this Message |
 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.