$"31-35")+$ COUNTIF $($

$(0-6$pts$)$ Write an Excel function in cell Summary! $85$ that calculates the number of females who are

between $22-25$ years, with an income greater than $$35,000$ and exercise $6$ or more hours per week.

$($DO not use cell references for the gender or age criteria.$)($Hint: Use the COUNTIFS$()$ function here with

$4$ sets of criteria. No $ check is needed since you are not copying down or across.$).$

$=$COUNTIFS$($criteria range of gender in Survey worksheet, female gender, criteria range of age category

in Survey worksheet, $22-25$ age category, criteria range of income in Survey worksheet, criteria of

income of $$35000,$ criteria range of number of exercise hours per week in Survey worksheet, criteria

of $6$ or more hours$)$

$=$ COUNTIFS

"Female",

$"22-25",$

$">35000",$

$||6")$

$(0-6$ pts$)$ Write an Excel function in cell Summary!B$6$ that calculates the total hours exercised by males

who earn more than $$50,000$ per year. $($Do not use cell references for the gender criteria.$)($Hint: Use