Count cells that meet either condition
{=SUM(IF((CellRange<5) + (CellRange>15), CellRange))}
Returns #N/A if any of the cells are not numeric
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top
{=SUM(IF((CellRange<5) + (CellRange>15), CellRange))}
Returns #N/A if any of the cells are not numeric