Difference between weeks

[Dummy Excel]

Hi All,
i am trying to work out the difference of sales between current week and the week prior.
my formula so far is:

=COUNTIFS(Historical!C:C,B2,Historical!$A:$A,A2,Historical!$I:$I,WEEKNUM(TODAY())-1)

im struggling to work out how to compare it to the current week.
any help will be greatly appreciated

thanks
Sam

 

[theBardd]

Seems to simple, but do you mean this?

=COUNTIFS(Historical!C:C,B2,Historical!$A:$A,A2,Historical!$I:$I,WEEKNUM(TODAY())-1)-COUNTIFS(Historical!C:C,B2,Historical!$A:$A,A2,Historical!$I:$I,WEEKNUM(TODAY()))

 

[Dummy Excel]

yes it was that simple and yes it works correctly
im just over complicating things and couldn't see it
appreciate your help