Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get a value returned when I require 2 criteria to be met
I am trying to get a count of occurances. For example;
I have a schedule for 20 people for a month and have "N" in varying days of the week and I need to have 2 separate counts for the occurance for each person. One for the days Mon,Wed,Fri. and another for Tue,Thur & Sun. Then I want to multipy the returned count by a specific value. In the case of Mon.,Wed., & Fri. I need to multipy by 1370, in the other case it is 1290. Any assistance would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multple criteria dilemma | Excel Worksheet Functions | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |