But isn't there a number of those awarded with each date, so you sum the
award numbers?

--
__________________________________
HTH

Bob

"Stilmovin" wrote in message
...
This equation returns the total of that range. What do i need to include
if i
just want them to be counted.

"Bob Phillips" wrote:

=SUMIF(E5:E80,"=10/9/2008",J5:J80)-SUMIF(E5:E80,"=10/10/2008"",J5:J80)

assuming award numbers in column J.


--
__________________________________
HTH

Bob

"Stilmovin" wrote in message
...
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!!