average question

[bluepenink]

Hello

im a little confused over a particular calculation

I have 12 months of data for i.e. a sales person's revenue

each month is a sum of their performance from Jan-Dec.

I have to evaluate what their averge revenue they generated during a "contest" time.

so i basically, =avg(Jan-March).

which is straight forward, however, if i already have their average, and I need to find out the average for all the sales ppl, in a city i.e. New york, i did the sum product on their average result.

now, do i need to divide the sum product by the numbers of weeks, if i already have their average pre-calculated?

thxs!

 

[Gerald Higgins]

Can you give us an example please ?
I've read your post a couple of times and can't work out what you want exactly.

 

[bluepenink]

Hello

John doe

sales
Jan-Feb-Mar-Apr-May-June-Jul-Aug-Sep-Oct-Nov-Dec
100-200-100-200-100-150-90-80-100-120-200-170

contest period (we;r looking to see if ppl generated more revenue) if we announced a contest period.

so contest period, March-May
average (100, 200, 100)
=$133

I did this for about 120 sales ppl.

Now, i need to know, how many ppl in the state i.e. state of florida, did during the time frame...

so i used a sumproduct rule and got a total for Florida.


where my confusion comes into play is, do i need to average out the sumproduct of florida?
i.e. divide by E22, where E22 is weeks in the contest period i.e. 3.

=SUMPRODUCT(--('Contest Effectiveness 2011'!$H$10:$H$137='Summary 2011'!$C39)*--('Contest Effectiveness 2011'!$M$10:$M$137))/$E$22

or should it simply be

=SUMPRODUCT(--('Contest Effectiveness 2011'!$H$10:$H$137='Summary 2011'!$C39)*--('Contest Effectiveness 2011'!$M$10:$M$137))


thxs alot!

 

[Gerald Higgins]

Sorry but I'm no clearer.