Sep 29 2020 06:48 AM
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
Sep 29 2020 01:36 PM
I guess hided H5 and H7 make the difference. To ignore them use =SUMPRODUCT(109,H3:H13)