Forum Discussion

Amyra Baig's avatar
Amyra Baig
Copper Contributor
Sep 26, 2018

HELP excel homework question

HI i need help with a question on my homework that i have been stuck on for two hours please help i'm actually about to cry because I havent been able to figure this out

 

Question 3: How many months in year X was the mean temp strictly less than Y degrees? (Use COUNTIFS and references to X and Y from their respective cells below)

 

X is 2008 and y is 70 attached below is the excel sheet its question 3

excel

1 Reply

  • Steven_Reid's avatar
    Steven_Reid
    Copper Contributor
    Sep 27, 2018

    Hi,

    not sure if you have already found an answer, but the following would work.

     

    the following gives an answer of 9

     

    =COUNTIFS(B64:B171,"="&D18,H64:H171,"<"&F18)