The reason is that you misplaced two right parenthesis.
This is how it should look like:

=SUMPRODUCT((E6:E80=DATE(2008,8,1))*(E6:E80<=DATE (2008,8,30))*(P6:P80<""))

Below I put in some linefeeds and spaces so that you can see easier
how the formula is built up.

=SUMPRODUCT(
( E6:E80=DATE(2008,8,1) )
*
( E6:E80<=DATE(2008,8,30) )
*
( P6:P80<"" )
)

Hope this helps / Lars-Åke

On Wed, 17 Dec 2008 07:47:14 -0800, Stilmovin
wrote:

=SUMPRODUCT((E6:E80=DATE(2008,8,1)*(E6:E80<=DATE (2008,8,30)*(P6:P80<""))))

why is this not returning the results i want. It is not counting up the
cells. i tryed changing the range and using different dates. but it keeps
turning up "0"?

"Lars-Åke Aspelin" wrote:

Yes, you may use the DATE function instead of a reference to a cell
holding the date, as pointed out by Glenn earlier in this thread.

Lars-Åke


On Tue, 16 Dec 2008 13:46:09 -0800, Stilmovin
wrote:

Alright sorry i forgot the "" behind them. That is why mine wasn't working.
Is there a way to get the equation to not relate to a specific cell but
Date(2008,5,1)

"Lars-Åke Aspelin" wrote:

And for that you have to read the last line of my answer (where there
is a 5 missing)

Lars-Åke

On Tue, 16 Dec 2008 11:44:08 -0800, Stilmovin
wrote:

Alright i used your formula to come up with a result and it would just sum. I
need it to count the number of awarded. not total the awarded.

"Lars-Åke Aspelin" wrote:

Read my answer again, particularly the line below the formula.

Lars-Åke


On Tue, 16 Dec 2008 10:39:01 -0800, Stilmovin
wrote:

=SUMPRODUCT((E5:E80=2008/5/1)*(E5:E80<=2008/5/31)*(P5:P80))
turned result = 0

Result should be = 3

"Lars-Åke Aspelin" wrote:

On Tue, 16 Dec 2008 10:15:02 -0800, Stilmovin
wrote:

I have been looking all over this site trying to find the answer and came up
with nothing.
I have a spread sheet that contains three columns: Date Cost Award
I am trying to count the number of awarded between a date(January)
I have tried the sumproduct and sumif equations to come up with the following

=COUNTIFS(P6:R93,"0",E6:E93,"2008Jan")
- #Value!

=COUNTIF(E5:E80,"=10/9/2008")-COUNTIF(E5:E80,"=10/10/2008")
- This resulted in only counting the dates and not the # of Awarded

HELP!!


Try this formula:

=SUMPRODUCT((E5:E80=startdate)*(E5:E80<=enddate)* (R5:R80))

where startdate and enddate are two cells with those dates, i.e. A1
and A2

The formula gives the sum of award for the corresponding dates.
If you just want to know the number of dates where there has been an
award, change R:R80 to R5:R80<"" in the last part of the formula.

Hope this helps / Lars-Åke