A
abuckeye
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?
than 2/1/06.
Any sugguestions?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
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)
=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)
A
Ardus Petus
=SUMPRODUCT((A1:A1000>=DATE(6,1,1))*(A1:A1000<DATE(6,1,2)),C1:C1000)
HTH
HTH
A
abuckeye
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.
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.
B
Bob Phillips
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)
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)