hello community,


after hours of web-search , trials and even chatgpt-not working-solution
i have to ask here:

i would like to (or must) sum up a column of 300 cells, where some cells are formulas.

i tried with many differnet syntaxes (here an example of nly 3 rows, where 1 has a formula in a cell):

=SUMME(WENN(ISTZAHL(AR12:AR14);AR12:AR14;0))

=SUMMEWENN(AR12:AR24;">0";AR12:AR24) + SUMMEWENN(AR12:AR24;"<0";AR12:AR24)

and different sumifs varations with "isfromula" and so on.

but all formulas do not ignore the formula in the cells and the result ist doubled !

can anybody help ?

thanx
stan