Excel iOS app sum problems

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)