Sales - Count Weeks on Offer (Retail)

[graemestown]

Hi

This is a retail problem.

I'm getting stuck on this one, would appreciate some help.
I need a formula that counts forward the number of weeks a style has been selling for. It must obviously only start counting from the first week a sale was recorded.
Example below.
Generally the prior weeks are recorded as blank.
Style 1 started selling for the first time in week 4, the formula then counts forward by dragging across how many weeks thereafter it sells for
Style 2 had its first week in week 8
Ideally the formula can be copied up down and sideways and will always start counting from the correct launch date

Thanks!

	Week	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
Style 1	Sales				1432	3358	3527	1105	926	715	595
Style 1	Count				1	2	3	4	5	6	7	etc
Style 2	Sales								477	1,119	1,176	368	309	238	198
Style 2	Count								1	2	3	4	5	6	7	etc
Style 3	Sales	239	560	588	184	154	119	99
Style 3	Count	1	2	3	4	5	6	7	etc

 

[awoohaw]

Try this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1		Week	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
2	Style 1	Sales				1432	3358	3527	1105	926	715	595
3	Style 1	Count				1	2	3	4	5	6	7
4
5	Style 2	Sales								477	1,119	1,176	368	309	238	198
6	Style 2	Count								1	2	3	4	5	6	7
7
8	Style 3	Sales	239	560	588	184	154	119	99
9	Style 3	Count	1	2	3	4	5	6	7
10
11
Sheet2

Cell Formulas
Range	Formula
C3:S3	C3	=IF(C$2="","",SUM(--ISNUMBER($C$2:C$2)))
C6:S6	C6	=IF(C$5="","",SUM(--ISNUMBER($C$5:C$5)))
C9:S9	C9	=IF(C$8="","",SUM(--ISNUMBER($C$8:C$8)))

 

[graemestown]

Thanks you, that's perfect!

 

[awoohaw]

Thanks you, that's perfect!

You're welcome.
Best Wishes.