Sumproduct for Month range with additional criteria problem

Posted on 2012-09-07
Last Modified: 2012-09-07
I am using the following formula to sum the data by month and where fund type equals "Unrestricted"  I am getting 0 as a value.  Any suggestions?


The formula works until I add in the "Unrestricted" contraint.
Question by:paxtonm
    LVL 39

    Expert Comment

    Try * instead



    Author Comment


    This still returns 0 as a solution.

    LVL 59

    Expert Comment

    by:Kevin Cross

    I think you want SUMIFS().

    LVL 39

    Accepted Solution

    It worked for me on your test spreadsheet, after I defined reportstartdate as 6/1/11, see attached.

    Since you're using that formula on a different format than your template, it's hard for me to say what the issue is.

    Sumifs is of course also an option



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    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

    21 Experts available now in Live!

    Get 1:1 Help Now