sumif

  • Thread starter Thread starter Fawn
  • Start date Start date
F

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
 
Hi
could you post some example rows of your data. Esp. what kind of date
value have you used
 
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
 
Back
Top