Excel iOS app sum problems

%3CLINGO-SUB%20id%3D%22lingo-sub-1724470%22%20slang%3D%22en-US%22%3EExcel%20iOS%20app%20sum%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1724470%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Sum%20function%20on%20my%20iOS%20Excel%20app%20seems%20to%20be%20getting%20the%20amounts%20off.%20In%20the%20example%2C%20it%E2%80%99s%20adding%2040%2B40%2B40%2B40%2B30%2B30%2B30%2B15%2B15%20as%20360%20rather%20than%20280.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20advise%20what%20might%20be%20going%20wrong%20here%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1724470%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

The Sum function on my iOS Excel app seems to be getting the amounts off. In the example, it’s adding 40+40+40+40+30+30+30+15+15 as 360 rather than 280.

 

Can anyone advise what might be going wrong here? Thanks

1 Reply

@Popconcern 

I guess hided H5 and H7 make the difference. To ignore them use =SUMPRODUCT(109,H3:H13)