Posted on 2012-09-11
Last Modified: 2012-09-18
If I have a column with a date in it and a column with a number, how do I format my equation to sumif the date =8-1-2012??

Question by:HDM
    LVL 10

    Accepted Solution

    If the dates were in the range C2:C10 and the numbers in D2:10 then:


    Author Comment


    Can I use a cell as the date??  So if in a1 I type 8-1-2012 it sould show the data for that date, then if I change the date it would update??

    Thanks for your help!!
    LVL 50

    Expert Comment

    by:barry houdini
    Yes, you can just replace the DATE part of tdlewis' suggested formula with the cell reference, e.g.


    regards, barry

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    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…
    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…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    761 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

    12 Experts available now in Live!

    Get 1:1 Help Now