Question

  • Creator
    Topic
  • #2136344

    Need Help with the SUMPRODUCT Function in Excel

    Locked

    by jdackerman ·

    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

All Answers

  • Author
    Replies
    • #2903512

      Clarifications

      by jdackerman ·

      In reply to Need Help with the SUMPRODUCT Function in Excel

      Clarifications

    • #2903045

      Wrong Function…

      by sven2157 ·

      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! 😉

Viewing 1 reply thread