How can I use SUMPRODUCT to sum the last 12 months

Posted on 2012-09-02
Last Modified: 2012-09-02
I have used the SUMPRODUCT formula to return the addition of the last 12 months of data
from another worksheet using Item, Month and Year as criteria. Can anyone correct the formula in the attached file.

I'm trying not to use any extra columns and will eventually use the formula in a macro.

Question by:user2073
    LVL 43

    Accepted Solution

    Two things are obviously wrong

    sumproduct uses direct formulas unlike sumif where the criteria is a string like ">"&...
    and the other is that sheet1 should be inside the EDATE function and not outside it.

    Here is the corrected formula. You can test the values returned


    Author Closing Comment

    Great this formula works well, I'm inspired by the knowledge you have.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now