Column A consists of dates (format example: Thursday, May 06). Date is
entered when vacation time or sick time is taken.
Column B consists of the hours of vacation for that day
Column C consists of the hours of sick time for that day

Column E consists of the months (January, February, etc.)
Column F consists of the hours of vacation taken for that month
Column G consists of the hours of sick time taken for that month

Can someone tell me what the formula would be for cells in columns F & G? I
imagine it would be some kind of lookup function or count function.

Thank you in advance

--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]

Hi
in F1 enter
=SUMPRODUCT(--(TEXT($A$1:$A$100,"MMMM")=E1),$C$1:$C$100)
and in G1 enter
=SUMPRODUCT(--(TEXT($A$1:$A$100,"MMMM")=E1),$B$1:$B$100)

"~Jeff~" wrote:

Column A consists of dates (format example: Thursday, May 06). Date is
entered when vacation time or sick time is taken.
Column B consists of the hours of vacation for that day
Column C consists of the hours of sick time for that day

Column E consists of the months (January, February, etc.)
Column F consists of the hours of vacation taken for that month
Column G consists of the hours of sick time taken for that month

Can someone tell me what the formula would be for cells in columns F & G? I
imagine it would be some kind of lookup function or count function.

Thank you in advance

--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]

F: =Sumproduct(--(TEXT(A1:A100, "mmmm")=E1), B1:B1000)
G: =Sumproduct(--(TEXT(A1:A100, "mmmm")=E1), C1:C1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"~Jeff~" wrote in message
...
Column A consists of dates (format example: Thursday, May 06). Date is
entered when vacation time or sick time is taken.
Column B consists of the hours of vacation for that day
Column C consists of the hours of sick time for that day

Column E consists of the months (January, February, etc.)
Column F consists of the hours of vacation taken for that month
Column G consists of the hours of sick time taken for that month

Can someone tell me what the formula would be for cells in columns F & G?
I
imagine it would be some kind of lookup function or count function.

Thank you in advance

--
~Jeff~
[Microsoft Windows XP Pro,Office 2000]