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 |
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 |