TheEnergyMan
New Member
- Joined
- Mar 12, 2019
- Messages
- 12
Occupancy | |
Occupancy Start | |
Occupancy End | |
Occupancy Start Weekend | |
Occupancy End Weekend | |
DHW | DHW |
DHW Start Monday | 05:00 |
DHW Start Tues - Fri | 05:30 |
DHW Stop Mon - Thurs | 15:00 |
DHW Stop Fri | 15:00 |
DHW Start Sat | 09:00 |
DHW Stop Sat | 13:00 |
DHW Start Sun | 00:00 |
DHW Stop Sun | 00:00 |
Cylinder Temps (°C) | 61.0°C |
<colgroup><col><col></colgroup><tbody>
</tbody>
So, see the above in excel, 2 columns 16 rows
I am trying to use the function in Cell B3 :
{=MAX(IF(AND(B7:B609 <> 0, $A$7:$A$609 <> ISNUMBER(SEARCH("Sat",$A$7:$A$609)), $A$7:$A$609 <> ISNUMBER(SEARCH("Sun", $A7:$A609))), B7:B609)) }
To find the max value (latest time) in the range that is < 1 (so that the Temp value isn't included) and only use the cells that do not contain Sat or Sun
the formula returns 0 ??
when i Use the formula : =MAX(IF(B7:B610 < 1,B7:B610))
It works Fine but i dont want the Sat and Sunday values in there only the weekly values
thanks in advance for any help