Count cells that meet either condition

{=SUM(IF((CellRange<5) + (CellRange>15), CellRange))}
Returns #N/A if any of the cells are not numeric


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top