We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

Calc: Sum only numbers entered manually (where ISFORMULA returns FALSE)? [closed]

asked 2015-05-22 01:43:16 +0200

frankqux gravatar image

updated 2020-08-21 16:22:20 +0200

Alex Kemp gravatar image

Hi, I have a column of cells and each cell has a number. Some of the numbers are the result of a formula and some numbers were entered manually.

Is there a way to sum only those cells whose numbers were entered manually? I've tried different combinations of SUMIF, NOT, and ISFORMULA but I haven't been able to get anything working.

I'm using LO v4.4.2.2.

Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-21 16:23:57.538145

2 Answers

Sort by » oldest newest most voted
1

answered 2015-05-22 09:55:41 +0200

pierre-yves samyn gravatar image

Hi - I am afraid that FORMULA and ISFORMULA do not support matrix form. So use an additional column (which can be hidden). See the attached exampl: IsFormulaSum.ods

edit flag offensive delete link more

Comments

This seems to be a bug. I filed a report here: https://bugs.documentfoundation.org/s...

Lupp gravatar imageLupp ( 2015-05-23 00:54:32 +0200 )edit
1

answered 2015-05-22 09:49:04 +0200

stephan66 gravatar image

updated 2015-05-22 10:14:16 +0200

Example:

There are 1000 numbers in A1:A1000.

Fill B1:B1000 with "=ISFORMULA()" pointing to the cell to the left.

=sumif(B1:B1000;FALSE;A1:A1000) should do the trick.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2015-05-22 01:43:16 +0200

Seen: 814 times

Last updated: May 22 '15