Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #608 Jul 3, 2012 www.energyefficientbuild.com.
user emailgarvin said:
IFERROR( sum) bug producing incorrect result.
The bug specifically does not add some columns together.
The formula of the IFERROR( sum) bug producing incorrect result.
If you please look at the second sheet called "Records" the formula in question relates to the first sheet called "Found":
=IFERROR( sum(Found!B6:B))+ IFERROR( sum(Found!L6:L))+ IFERROR( sum(Found!V6:V))
The formula adds from above (10+10)+(10+10)+(10+10)=60
however produces 40, Specifically the last section of formula is not being added:
i.e. + IFERROR( sum(Found!V6:V))
The public spreadsheet is here and editable.
Thank you for your time and reolving this bug.
----------------------------------------------------------------------------------
to my knowledge there is no bug
have a look at a couple of formulations presented herein as a solution to the problem
user emailgarvin said:
IFERROR( sum) bug producing incorrect result.
The bug specifically does not add some columns together.
The formula of the IFERROR( sum) bug producing incorrect result.
If you please look at the second sheet called "Records" the formula in question relates to the first sheet called "Found":
=IFERROR( sum(Found!B6:B))+ IFERROR( sum(Found!L6:L))+ IFERROR( sum(Found!V6:V))
The formula adds from above (10+10)+(10+10)+(10+10)=60
however produces 40, Specifically the last section of formula is not being added:
i.e. + IFERROR( sum(Found!V6:V))
The public spreadsheet is here and editable.
Thank you for your time and reolving this bug.
----------------------------------------------------------------------------------
to my knowledge there is no bug
have a look at a couple of formulations presented herein as a solution to the problem
No comments:
Post a Comment