Help for condition statments

[dummyboy]

Hi Guys,

I really need help from you all with my file. I have my attached excel sample here. I have basically 6 colums with Country,month,sale price, index price,year,quarter.
So i need to check my condition in the quarter cells. I need to return the sum of quarterly(sum of (jan, feb, march), (apr,may,jun) etc) sale price based on countries . your help will be much appreciated.

[oeldere]

Please Login or Register  to view this content.

I'm not all members, but maybe that will do for you also

I made an table of your data.

I used VLookup, to determine the quartal (there are other options to).

After that I made an pivot table of it.

After that I made an graph of it.

See the attached file.

Please reply.

[daffodil11]

I used a table of Country and Quarter in conjuntion with Sumproduct:

Attachment 261797

[dummyboy]

hello oeldere,

Many thanks for your reply . I really wouldnt want to put a pivot table as I wanted to take the results in the next sheet in trhe similar format. so basically my next sheet will be with the four quarters,(Q1,Q2,Q3 etc) for the countries which are reference to the current sheet. Do you think any other ways?

[dummyboy]

daffodil,
Many thanks. I tried to work on the formula you have posted and it works somewhat fine for me.

I have attached my file so you can have a look at what i need. Is there any possible way where I can automate little more (instead of changing the month for each quarter like "Jan","feb", "mar" "apr,"may","jun" etc?

Once again your earlier post was very helpful!!! thank you

[oeldere]

@dummyboy

You could use the vlookup I used to dertermine the quarter.