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%3CLINGO-SUB%20id%3D%22lingo-sub-1726385%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20iOS%20app%20sum%20problems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1726385%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F813351%22%20target%3D%22_blank%22%3E%40Popconcern%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20hided%20H5%20and%20H7%20make%20the%20difference.%20To%20ignore%20them%20use%20%3DSUMPRODUCT(109%2CH3%3AH13)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted

@Popconcern 

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