Hi
I have currently set up a sumif formula and linking the criteria to a week drop down list.
so if I select the week no say 25 and it display my sum if value. I would like to also display 4 previous value. Can someone tell me which formula I can use to display the previous value below
the display would look like this:
21 22 23 24 25
50 75 100 200 400
I have currently set up a sumif formula and linking the criteria to a week drop down list.
so if I select the week no say 25 and it display my sum if value. I would like to also display 4 previous value. Can someone tell me which formula I can use to display the previous value below
the display would look like this:
21 22 23 24 25
50 75 100 200 400
Last edited:
