Count cells in a table when a column meets 1 condition

blank
{=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


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