TechRepublic|Forums|Software

Software

Question

  • Creator
    Topic
  • April 29, 2013 at 1:12 pm #2136344

    Need Help with the SUMPRODUCT Function in Excel

    Locked

    by jdackerman · about 9 years, 5 months ago

    I am Having a issue with the SUMPRODUCT Function in Excel 2007. Here is my string and issue:

    =SUMPRODUCT(($B$2:$B$800>DATE(2013,4,1))*($B$2:$B$800

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Answers

  • Author
    Replies
    • April 29, 2013 at 1:12 pm #2903512

      Clarifications

      by jdackerman · about 9 years, 5 months ago

      In reply to Need Help with the SUMPRODUCT Function in Excel

      Clarifications

    • May 3, 2013 at 3:16 pm #2903045

      Wrong Function…

      by sven2157 · about 9 years, 5 months ago

      In reply to Need Help with the SUMPRODUCT Function in Excel

      I believe that you want to use COUNTIF(). This function takes 2 arguments:

      [b]COUNTIF( range, criteria )[/b]
      [b][u]range[/u] – is the cells that you want to include[/b]
      [b][u]criteria[/u] – is what you are looking to count[/b]

      So you would want something more like( Using your example data above ):

      [b]=COUNTIF($B$2:$B$800,”>4/1/2013″)-COUNTIF($B$2:$B$800,”<4/5/2013″)[/b]

      *** EDIT ***
      Upon posting I noticed that the LessThan symbol will not display in the second part of the function; just before the date 4/5/2013. I had to add the HTML Entity code in order for it to work.

      Hope that helps! 😉

  • Author
    Replies
Viewing 1 reply thread