try:
Code:
=SUM(FILTER(AR12:AR14;ISERROR(FORMULATEXT(AR12:AR14))))
or in German if I've got it right:
Code:
=SUMME(FILTER(AR12:AR14;ISTFEHLER(FORMELTEXT(AR12:AR14))))
edit: Ach, I just realised you're using Excel 2019... I'll think again.
edit2: You mention ISFORMULA so your version of Excel is at least 2021? If so the formula above should work.
Here's one with ISFORMULA:
Code:
=SUMME(NICHT(ISTFORMEL(AR12:AR14))*AR12:AR14)
Code:
=SUM(NOT(ISFORMULA(AR12:AR14))*AR12:AR14)