How to sum data based on week using SUMIF Microsoft Excel

this video will guide you to sum data based on week, using SUMIF function. later i will make a video do the same thing but use sumproduct function

exercise table, you can find here:

[Przedpotopowiec]

I am so glad that I found you!!! THANK YOU

[tibiajundii]

Thank you so much! This is exactly what I needed

[ismaelcheick]

Interesting tip, Can you make a video with sumproduct?

[ubernagash]

Hi its been a while since i used excel, but i am trying to figure out how to do a weekly incress of a vaule.
Say a vaule is £8.00 on week x, it will change each week automaticly by adding the same amount when i open it. So 1st week £8.00 next week £16 then £24 and so on.
I think it done using the sumif but i cannot remember the formula.
If you can help that would be good if no worries and thanks 🙂