Software

Ask something
Question Locked

Need Help with the SUMPRODUCT Function in Excel

0 helpful
2 replies

by jdackerman

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by sven2157

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! ;-)

This discussion is closed to new replies.