Add up the hours for each month
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] |
All times are GMT +1. The time now is 05:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com