Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct 3 criteria inc. date
byI have set up successful SUMPRODUCT to count the number of people in a
particular job, by depot, and where the 'leave date' column is empty. I would like to count the number of people in a particular job, by depot, by month. The value in the 'startdate' column is a date dd/mm/yyyy. I have tried to follow the answers given in previous posts, with no luck. Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct and IF criteria?? | Excel Discussion (Misc queries) | |||
SUMPRODUCT, two criteria (date and product type) | Excel Worksheet Functions | |||
Sumproduct 4 criteria | Excel Worksheet Functions | |||
SUMIF/SUMPRODUCT/IF - 2 criteria - Date and Text | Excel Discussion (Misc queries) | |||
Sumproduct w/date criteria not working | Excel Worksheet Functions |