Hi Dhanesh, =SUMIFS(F3:R3,F2:R2,">="&B3,F2:R2,"<="&C3)
will total the periods whose date (as specified in row 2 -- appears to be month-ending date) falls between the specified dates in B3 and C3. =COUNTIFS(F2:R2,">="&B3,F2:R2,"<="&C3) will count the number of periods that actually appear in the table and whose designated date falls within the date range. Hope this is useful to you. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhanesh Verma Sent: Tuesday, May 01, 2012 1:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fixing the problem Dear Friends, I want to put a formula in the attached sheet to calculate automatically as and when I change the periods., please help.. Rgds Dhanesh DISCLAIMER AND PRIVILEGE NOTICE : This e-mail and any files transmitted with it contain confidential, copyright, proprietary and legally privileged information. It should not be used by anyone who is not the original intended recipient. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of DEN Networks Ltd., its subsidiaries, holding companies i.e. DEN shall be understood to be neither given nor endorsed by DEN. Internet communications cannot be guaranteed to be timely, Secure, error or virus-free. The sender does not accept liability for any errors or omissions." -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
