Tuesday, July 3, 2012

yogi_Compute Sum Of Entries In Specified Columns Containing Both Numeric And Text Entries

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