Count cells that contain numbers with multiple conditions
{=SUM((CellRange>5) * (CellRange<15) * CellRange)}
Returns #N/A if any of the cells are not numeric
{=SUM((IF(ISERROR(CellRange),0,CellRange)>5)*(IF(ISERROR(CellRange),0,CellRange)<15)*IF(ISERROR(CellRange),0,CellRange))} = 156
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top