Just remember it always pays to think how other people will interpret your
written words. Since we can't see you and can't hear you speak all we see
are words.

Does Max's formula help?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Jane" wrote:

I am sorry... I in no way wanted it to sound like that at all!

I have a project due tomorrow and needed help as soon as possible. I posted
the question on Friday an no one asnwered so I hoped to get help as soon as I
could.

This group has helped me so many times an woul never want to offend them.

Whenever I post, I have always tried to be specific but was not sure where
this question fell.

"Dave F" wrote:

Ha.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Don Guillett" wrote:

Why is your need more important than any other's. ASAP sounds like we are
your employees.



--
Don Guillett
SalesAid Software

"Jane" wrote in message
...
Data:
A B C D E F G H
Season
Ratio
Jan. Feb. Mar. Apr. May Jun avg. to Ssn avg.
182.83 804.25 423.68 263.66 388.32 319.83 2944.66 x
210.09 427.43 380.02 1941.79 x
0 0 518.18 411.43 415.57 251.04 3343.16 x

Facts:
- Columns A - F = store sales
- Column G row 1 = COMPANY average of store's averages below
- Columns G row 2-4 = STORE averages of months in columns A - F
- Each store is coded "NC" and they are among other stores that are coded
"COMP" and not shown here.
- Column H needs to = ratio of STORE'S sales average to COMPANY average -
with a catch


I need a formula that says
if the store is coded NC, calculate the ratio to COMPANY average - teh
COMPANY average must be an average that 1) sums the Company averages for
months in which the STORE's monthly data is 0 and 2) starts at the 2nd
month
in which there is STORE data.

ie
For store 1, the Company average would include Feb - Jun
Fro store 2, the Company average would include May - Jun
For store 3, the Company average would include Apr - Jun

thank you in advance! Jane