Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
multiple criteria in if or sumproduct
I am trying to set up a leave time report for people to use. The format is below: Date Type or Leave Hours Taken 07/01/2005 A 8 07/15/2005 A 6 08/15/2005 S 5 etc etc etc I need a formula to look at the date and find all leave taken for a specific type of leave for the month and then total the hours taken for that month. For instance, in the above example 14 hours for the month of July. I only need the result of 14. Please help. :) -- tbird0566 ------------------------------------------------------------------------ tbird0566's Profile: http://www.excelforum.com/member.php...o&userid=27375 View this thread: http://www.excelforum.com/showthread...hreadid=468942 |
#2
|
|||
|
|||
Let A1:C4 house the sample you provided.
In E2 enter: 1-Jul-2005 which you might want to format as Jul-05 for display purposes. In F2 enter: A which is a type value. In G2 enter: =SUMPRODUCT(--($A$2:$A44-DAY($A$2:$A$4)+1=E2),--($B$2:$B$4=F2),$C$2:$C$4) tbird0566 wrote: I am trying to set up a leave time report for people to use. The format is below: Date Type or Leave Hours Taken 07/01/2005 A 8 07/15/2005 A 6 08/15/2005 S 5 etc etc etc I need a formula to look at the date and find all leave taken for a specific type of leave for the month and then total the hours taken for that month. For instance, in the above example 14 hours for the month of July. I only need the result of 14. Please help. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions | |||
Using Sumproduct with multiple Criteria | Excel Worksheet Functions | |||
Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
sumproduct using multiple criteria | Excel Worksheet Functions | |||
Sumproduct - multiple criteria in Column A | Excel Worksheet Functions |