Count cells that are text and n characters long
blank
{=SUM(IF((CellRange<5) + (CellRange>15), CellRange))}
Returns #N/A if any of the cells are not numeric
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top
blank
{=SUM(IF((CellRange<5) + (CellRange>15), CellRange))}
Returns #N/A if any of the cells are not numeric