Feb 16 2019 07:09 AM
Hello, Im pretty new to excel, can anyone give me a hand?
Im trying to add up every 3rd cell in my table. (Looking at cell E3, addind up "product focus sales" for each week. for each person)
I've tried using this - " =SUM(E6:E110*(MOD(ROW(E6:E110),3)=0))" It has returned a #Value Error
I have also tried using this - "=SUMPRODUCT(E6:E110,--(MOD(ROW(E6:E110)-ROW(E6)+1,3)=0))" And it returns "0.034740044" which is completly incorrect.
Heres the link to my document, If you dont mind having a look, that'll help me out a lot!
Feb 16 2019 07:31 AM
Hi,
With SUM you shall use array formula (Ctrl+Shift+Enter), but SUMPRODUCT returns correct result. 0.0347 that's just 3.47% which is correctly sums 0.3% in E14, and 3.17% in E17, all the rest are zero.
Please check attached.
Feb 19 2019 03:48 AM