Exclude Cells with Formulas in a sum

p45cal · #4 11-17-2024, 06:39 AM

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)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to duplicate a block of cells that contain formulas without losing reference?	ColtonYYZ	Excel	2	10-31-2022 11:46 AM
Ctl Shift Arrow to Exclude Formulas	julien	Excel	3	05-11-2018 05:08 AM
Empty cells with formulas	Mihai Vultureanu	Excel	2	02-01-2018 05:30 PM
Averaging cells with formulas	petale	Excel	2	08-10-2016 09:44 PM
How to transfer multiple cells from excel to word by formulas	justziggy	Word	5	05-23-2009 02:33 AM