Forum Discussion
How do I analyze temperature and humidity data?
I have an excel file with columns of date and time, temperature and humidity data, with rows of samples taken every ten minutes. I want to determine the amount of time temperature and humidity were ...
I'd use a helper column. Let's say the temperatures are in column C, and the humidity data in column D, starting in row 2.
Enter the following formula in E3 (we don't need a formula in E2, since there is no data row above it):
=COUNTIFS(C2:C4,">=24",D2:D4,">=42%")=3
Fill down.
The formula returning the number you want is
=COUNTIF(E:E,TRUE)