Try this:

=SUMPRODUCT(--(TEXT(A2:A7,"m/yyyy")="10/2007"),B2:B7)

--
Biff
Microsoft Excel MVP


"Delsy" wrote in message
...
We track attendance per individual person on one worksheet. We only enter
the
dates that the person is out. I want a SUMIF formula that will only tell
me
the total sum of columnB between a certain range of dates.

For example: for October this person was out 2 days (of a total 4.5 days
out).

Date Absent Full/Half Day
8/31/07 1.0
9/4/07 0.5
9/24/07 1.0
10/01/07 0.5
10/25/07 1.0
10/26/07 0.5

Networkdays will count the number of days between two days, but won't
total
half days. Is there any formula that will do this?