• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum formula

ridwanr

New Member
Hi all,

Anybody can help me on a formula whereby I have to add up several column. But the fact is that I cannot use simple sum as there are several sheet in the file and everyday the column keep changing. See attached file for better understanding.

I want a formula that whenever the column keep increasing I can add data for the month of January and June only without taking into consideration other month.

Thanks & regards,
Ridwan
 

Attachments

  • Ridwan example.xlsx
    10.9 KB · Views: 5
Hello ... You can Use This
Code:
=SUMIF(INDIRECT("'"&$L$2&"'!$A$2:$A$4"),$A2&"*",INDEX(INDIRECT("'"&$L$2&"'!$B$2:$G$4"),0,MATCH(B$1,INDIRECT("'"&$L$2&"'!$B$1:$G$1"),0)))
 

Attachments

  • Ridwan example1.xlsx
    12 KB · Views: 8
Back
Top