Use the summit formula to calculate the sum of annual sales where the value in the regions named range is equal to the region listed in B9.
a) =SUMIF(Regions, B9, Annual Sales)
b) =SUMIFS(Annual Sales, Regions, B9)
c) =SUMPRODUCT(Annual Sales, --(Regions = B9))
d) =SUM(Annual Sales:B9)