Sum absolute numbers, ignore text and formulas

[virtuosok]

Hi,
I have a range G5:AH5 which contains a mix of regular numbers, negative numbers, text, blanks and formulas.
Am trying to get a sum of numbers only, ignoring everything else. The following
=SUMPRODUCT(ABS(G5:AH5))
{=SUM(ABS(G5:AH5))}
...both return the #VALUE! error
Any ideas please to avoid helper columns....

 

[virtuosok]

Figured this out
=SUM(IF(ISNUMBER(G5:AH5),ABS(G5:AH5)))