Ask Your Question

Sum of formulated range not working.

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

SteveLFC gravatar image

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

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?



edit retag flag offensive close merge delete


could someone add [solved - formatting error] or similar to the tile

newbie-02 gravatar imagenewbie-02 ( 2019-12-14 10:44:18 +0100 )edit

1 Answer

Sort by » oldest newest most voted

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

Ratslinger gravatar image


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


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

Ratslinger gravatar imageRatslinger ( 2019-09-11 03:49:03 +0100 )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 +0100 )edit


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 +0100 )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 +0100 )edit

Please, if the answer solves the question click ✔.

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

Question Tools

1 follower


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

Seen: 56 times

Last updated: Sep 11 '19