Ask Your Question
0

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

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

frankqux gravatar image

updated 2015-08-26 21:34:21 +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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 564 times

Last updated: May 22 '15