Hi Techies,
I have an Excel spreadsheet that tracks hourly temperature and relative humidity for Level 1 and Level 2. It uses averages, and minimum and maximum values.
I've attached it to make it easier to follow my issue.
In the range B12:AW12, I've averaged the readings for temperature and relative humidity for each level, each day.
In cell AX12, I've averaged the combined temperature averages for Level 1 with this formula:
It works great!
In cell AY12, I want to average the combined humidity averages for Level 1. I can't even get the SUMIFS part to return anything except 0.0, when the syntax for it is practically identical to the SUMIFS in AX12 that works:
It should return 202.9, but all I get is a big, fat 0.0.
Could someone smarter than me please lend a hand? I'd be ever so grateful!
Thank you!
I have an Excel spreadsheet that tracks hourly temperature and relative humidity for Level 1 and Level 2. It uses averages, and minimum and maximum values.
I've attached it to make it easier to follow my issue.
In the range B12:AW12, I've averaged the readings for temperature and relative humidity for each level, each day.
In cell AX12, I've averaged the combined temperature averages for Level 1 with this formula:
Code:
=SUM(SUMIFS(B12:AW12,B2:AW2,"Level 1",B3:AW3,"C°")/COUNTIFS(B2:AW2,"Level 1",B3:AW3,"C°",B12:AW12,"<>0"))
It works great!
In cell AY12, I want to average the combined humidity averages for Level 1. I can't even get the SUMIFS part to return anything except 0.0, when the syntax for it is practically identical to the SUMIFS in AX12 that works:
Code:
=SUMIFS(B12:AW12,B2:AW2,"Level 1",B3:AW3,"RH%")
It should return 202.9, but all I get is a big, fat 0.0.
Could someone smarter than me please lend a hand? I'd be ever so grateful!
Thank you!