COUNTIFS and factoring in a 3rd column

[dcouch]

Hi everyone, I hope you can see the image I've attached

I've got a .csv file which has temperature readings every minute so each cell is 1 minute

Basically I want to count the number of cells between 85 and 95 but only when a 3rd column is equal to 93

The 93 is the oven setpoint so I need to know when it levels out onto 93

I've got this formula now but it doesn't seem to factor in G it still just counts what is within N

=COUNTIFS(N30:N296,">"&85, N30:N296,"<="&95, $G$25:$G$291, 93)

This is in excel 2010

Thanks

 

[dcouch]

[/URL][/IMG]

 

[AlanY]

your data are out of sync, are they intended?


=COUNTIFS(N30:N296,">"&85, N30:N296,"<="&95, $G$25:$G$291, 93)

 

[dcouch]

No it wasn't. Something so simple completely eluded me

Thank you!!

 

[AlanY]

you're welcome