sumif

[Fawn]

I have 12 different sheets in a workbook. All of them represents sales for
12 months. I have defined the salesperson column and the revenue column.
So what I have used is Januarysales and Januaryrevenue etc for the following
months.

What I want to do is to define a Quarter to only calculate certain months
depending on the quarter chosen.

For example is cell c1 = Q1, then I want to calculate Jan, Feb and March
revenue only. Then if Cell c1=Q2 then I want this to calculate April, May
and June.

Is this possible

Any help would be appreciated

Thanks

 

[Frank Kabel]

Hi
could you post some example rows of your data. Esp. what kind of date
value have you used

 

[Fawn]

An example will be

Salesperson Revenue Percentage of Target

Jack 20,000.00 98
Sue 5,000.00 100
Ken 10,000.00 68



The salesperson each month will not always be the same value, however the
Revenue will always be a different value. This is then ranked by percentage
so each sheet will not be in the same order. What I have done is defined
each column with a name range and used the following formula on the YTD
sheet.

sumif(januarysales,a1,revenuejan)+sumif(febsales,a1,revenuefeb) and so on
for each month.

I want to set up one absolute cell that will have either Q1, Q2,Q3 or Q4.
representing Quarters of the revenue for the year. Right now I have all 12
sheets calculating in there. But I want to extract only certain months
using the "IF" statement.

So If cell A47 = Q1 then calculate only month Jan, Feb and March.

Is this possible.

Thanks for you help