I know this is not a programming question but I'm looking for an answer from those who understand the cpu/memory impact of formulae.

I have a source table:
a)Year b)Week c)Item Code d)Sales

I have a sumifs saying
=SUMIFS(Sales,A:A,2010,B:B,">=30",B:B,"<=33",C:C,Itemv1)+
SUMIFS(Sales,A:A,2010,B:B,">=30",B:B,"<=33",C:C,Itemv2)

Some times 1 item has two itemcodes though so i add an exact sumifs for v2 of the Item.

Is there a better way?