G Guest May 31, 2006 #1 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?
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?
B Bob Phillips May 31, 2006 #2 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)
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)
A Ardus Petus May 31, 2006 #3 =SUMPRODUCT((A1:A1000>=DATE(6,1,1))*(A1:A1000<DATE(6,1,2)),C1:C1000) HTH
G Guest May 31, 2006 #4 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.
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.
B Bob Phillips May 31, 2006 #5 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)
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)
