• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If function in getting Qtr wise sales

Dee

Member
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

Excel Ninja
Staff member
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)
 
Top