If function in getting Qtr wise sales

[Dee]

Hi,


I am trying to get Qtr wise sales from Year and quarter column.i have few columns containing Sales, year, Quarter.I am trying to get quarter wise sales using Year, quarter & sales columns.If sales is 300 year is 2009 and Quarter is 3rd then it should value 300 in Q3 of 2009. IF year 2010 then it should give in Q3 of 2010. There are different quarterly sales for each region.

Thanks

Dee

 

[Hui]

If

A2:A200 is Year

B2:B200 is Qtr

C2:C200 is Region

D2:D200 is Sales

try

=Sumproduct(+1*(A2:A200=2009)*(B2:B200="3RD")*(C2:C200="Region name"),D2:D200)