Sum If ???
 

I want to sum column C if Column A is greater than or equal to 1/1/06 & less
than 2/1/06.

Any sugguestions?

Sum If ???
 

Put those dates in D1 and D2

=SUMIF(A:A,"="&D1,C:C)-SUMIF(A:A,"<="&D2,C:C)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"abuckeye" wrote in message
...
I want to sum column C if Column A is greater than or equal to 1/1/06 &
less
than 2/1/06.

Any sugguestions?

Sum If ???
 

=SUMPRODUCT((A1:A1000=DATE(6,1,1))*(A1:A1000<DATE (6,1,2)),C1:C1000)

HTH
--
AP

"abuckeye" a écrit dans le message de
news: ...
I want to sum column C if Column A is greater than or equal to 1/1/06 &
less
than 2/1/06.

Any sugguestions?

Sum If ???
 

its more complicated than that
Col A
list of dates an employee was absent

Col C, E & G (diff types of time off)
hours of time off they used

I want a formula to sum for "January" all hours used of time off.

"Ardus Petus" wrote:

=SUMPRODUCT((A1:A1000=DATE(6,1,1))*(A1:A1000<DATE (6,1,2)),C1:C1000)

HTH
--
AP

"abuckeye" a écrit dans le message de
news: ...
I want to sum column C if Column A is greater than or equal to 1/1/06 &
less
than 2/1/06.

Any sugguestions?

Sum If ???
 

We were supposed to know that?

And now we are supposed to know what the time off codes are?

I think you would do well to map out the full problem with data.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"abuckeye" wrote in message
...
its more complicated than that
Col A
list of dates an employee was absent

Col C, E & G (diff types of time off)
hours of time off they used

I want a formula to sum for "January" all hours used of time off.

"Ardus Petus" wrote:

=SUMPRODUCT((A1:A1000=DATE(6,1,1))*(A1:A1000<DATE (6,1,2)),C1:C1000)

HTH
--
AP

"abuckeye" a écrit dans le message
de
news: ...
I want to sum column C if Column A is greater than or equal to 1/1/06 &
less
than 2/1/06.

Any sugguestions?