Ask Your Question
0

Sum of formulated range not working.

asked 2019-09-11 03:32:42 +0200

SteveLFC gravatar image

updated 2019-09-11 22:38:25 +0200

I am trying to sum a range where each cell in the range is the result of a formula, but for some reason it doesn't work, the sum is always zero. I have created a simplified reproducible case. See attached image and spreadsheet demonstrating the problem. Any ideas?

C:\fakepath\SumOfFormulatedRangeIssue.png

C:\fakepath\SUM OF FORMULATED RANGE PROBLEM.ods

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2019-09-11 03:45:09 +0200

Ratslinger gravatar image

Hello,

There should be no quotes surrounding the 1 in the formulas:

=IF(B4="Y", "1", 0)

should be:

=IF(B4="Y", 1, 0)
edit flag offensive delete link more

Comments

P.S. There is not need to yell out your question - ALL CAPS.

Ratslinger gravatar imageRatslinger ( 2019-09-11 03:49:03 +0200 )edit

Thank you for your answer. For your information the title I copied and pasted in a hurry from the spreadsheet which is capitalised, just a simple matter I overlooked but then in my world a title being capitalised or emboldenned is commonplace since its a title, its not intended to mean anything else, so you shouldn't be so quick jump to conclusions.

SteveLFC gravatar imageSteveLFC ( 2019-09-11 12:27:25 +0200 )edit

@SteveLFC,

You are correct. I should have only stated to "Please not use all caps in your question as this is taken by most as yelling".

Ratslinger gravatar imageRatslinger ( 2019-09-11 18:20:01 +0200 )edit

No worries. I cant believe I even asked this question, its so obvious, I cant believe I didn't notice the quotes, clearly Ive been working too long and too late :)

SteveLFC gravatar imageSteveLFC ( 2019-09-11 22:47:29 +0200 )edit

Please, if the answer solves the question click ✔.

m.a.riosv gravatar imagem.a.riosv ( 2019-09-11 23:05:13 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-09-11 03:32:42 +0200

Seen: 34 times

Last updated: Sep 11