Expected Figures

[RIZVI]

I am using Excel 2007.

I have a table wherein I have

1. Customer names in coumun EB7 till EB101.
2. Heading EB3 is "Customer Name".
3. Row ED3 till EO3 is the name of months viz: April, May, June......till March.
4. Cell EP3 is heading "Total".
5. Sales billed to each customer is fiiled in table range ED7 till EO101
6. Total sales made by the customer is calculated in clumn EP7 till EP101.
7. Total sales of each months is calculated in row ED102 till EO102.

Now each sustome buys as per their requirements, but seem to be having a pattern. Some buy every month, some alternate month, some once in a three months etc. Pattern varies from customer to customer.

Based on the pattern and their usual off-take I need to know
A) The likelyhood of a customer buying or not buying in next month.
B) Value a customer is likely to buy.

A) If I can know this then we can depute our sales person or call our customer well in advance before they plan to go to other store / supplier. (Also save our sales staff's effort, time and money by avoiding the vsits to the customer who are not likely to buy that month)
B) Plan our inventory acordingly so that as and when the customer places the order we are able to supply them in time.

Trendline does not works propelry as:

1. I have to make chart for each and every customer.
2. Have to make it every month.
3. Does not provides me with the value a customer is likely to buy.

Can you help me with some way wherein I can get a figure of 0 if customer is not likely to buy and with a value if the customer is likely to buy in cells in some column against each customer name. Say in row EC???

Pleas help.

With regards,

Rizvi.M.H.

 

[crusader]

I am using Excel 2007.
Can you help me with some way wherein I can get a figure of 0 if customer is not likely to buy and with a value if the customer is likely to buy in cells in some column against each customer name. Say in row EC???

While PivotTable may not give you the numbers you are seeking, it will show you a trend (if there is one).

 

[RIZVI]

I know about the trend. I am specifically looking for Numbers 0 or otherwise agianst each customer name in coloumn EC.

Trend is not servng my purpose for the reasons already mentioned.

Awaiting a suitable support and guidance.

RGDS,

Rizvi

 

[RIZVI]

I do not understand why no help is forthcoming this time. Each day I check my mail in expectation. Can any one help please.

NO trendlines please. It dones not suits my requiements.

RGDS,

Rizvi.M.H.

 

[RIZVI]

Excel Workbook
	ED	EE	EF	EG	EH	EI	EJ	EK	EL	EM	EN	EO	EP
3	Apr-11	May-11	Jun-11	Jul-11	Aug-11	Sep-11	Oct-11	Nov-11	Dec-11	Jan-12	Feb-12	Mar-12	Total Sales
4
5
6
7	0	0	3572	3250	28511	4478	0	0	0	0	0	0	39811
8	0	0	0	4865	0	0	7930	0	0	0	0	0	12795
9	0	13788	0	0	0	0	7828	0	0	0	0	0	21616
10	0	3730	0	0	0	4150	0	0	0	0	0	0	7880
11	0	0	13288	0	0	0	0	0	0	0	0	0	13288
12	0	0	0	0	0	5800	0	0	0	0	0	0	5800
13	0	0	7100	0	0	0	0	0	0	0	0	0	7100
14	4658	0	0	0	23609	24690	7429	0	0	0	0	0	60386
15	6994	23763	6258	0	0	0	3705	0	0	0	0	0	40720
16	0	0	0	565	0	0	0	0	0	0	0	0	565
17	0	0	0	0	6250	9400	0	0	0	0	0	0	15650
18	0	0	6227	0	0	0	0	0	0	0	0	0	6227
19	0	3940	0	0	0	0	0	0	0	0	0	0	3940
Sales & Purchases

Excel 2007

Cell Formulas
Range	Formula
ED7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-04-2011",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">30-04-2011",('Back Calculations'!$C$6:$C$816))
ED8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-04-2011",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">30-04-2011",('Back Calculations'!$E$6:$E$816))
ED9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-04-2011",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">30-04-2011",('Back Calculations'!$G$6:$G$816))
ED10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-04-2011",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">30-04-2011",('Back Calculations'!$I$6:$I$816))
ED11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-04-2011",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">30-04-2011",('Back Calculations'!$K$6:$K$816))
ED12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-04-2011",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">30-04-2011",('Back Calculations'!$M$6:$M$816))
ED13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-04-2011",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">30-04-2011",('Back Calculations'!$O$6:$O$816))
ED14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-04-2011",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">30-04-2011",('Back Calculations'!$Q$6:$Q$816))
ED15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-04-2011",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">30-04-2011",('Back Calculations'!$S$6:$S$816))
ED16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-04-2011",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">30-04-2011",('Back Calculations'!$U$6:$U$816))
ED17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-04-2011",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">30-04-2011",('Back Calculations'!$W$6:$W$816))
ED18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-04-2011",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">30-04-2011",('Back Calculations'!$Y$6:$Y$816))
ED19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-04-2011",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">30-04-2011",('Back Calculations'!$AA$6:$AA$816))
EE7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-05-2011",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">31-05-2011",('Back Calculations'!$C$6:$C$816))
EE8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-05-2011",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">31-05-2011",('Back Calculations'!$E$6:$E$816))
EE9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-05-2011",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">31-05-2011",('Back Calculations'!$G$6:$G$816))
EE10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-05-2011",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">31-05-2011",('Back Calculations'!$I$6:$I$816))
EE11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-05-2011",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">31-05-2011",('Back Calculations'!$K$6:$K$816))
EE12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-05-2011",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">31-05-2011",('Back Calculations'!$M$6:$M$816))
EE13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-05-2011",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">31-05-2011",('Back Calculations'!$O$6:$O$816))
EE14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-05-2011",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">31-05-2011",('Back Calculations'!$Q$6:$Q$816))
EE15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-05-2011",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">31-05-2011",('Back Calculations'!$S$6:$S$816))
EE16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-05-2011",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">31-05-2011",('Back Calculations'!$U$6:$U$816))
EE17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-05-2011",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">31-05-2011",('Back Calculations'!$W$6:$W$816))
EE18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-05-2011",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">31-05-2011",('Back Calculations'!$Y$6:$Y$816))
EE19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-05-2011",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">31-05-2011",('Back Calculations'!$AA$6:$AA$816))
EF7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-06-2011",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">30-06-2011",('Back Calculations'!$C$6:$C$816))
EF8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-06-2011",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">30-06-2011",('Back Calculations'!$E$6:$E$816))
EF9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-06-2011",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">30-06-2011",('Back Calculations'!$G$6:$G$816))
EF10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-06-2011",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">30-06-2011",('Back Calculations'!$I$6:$I$816))
EF11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-06-2011",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">30-06-2011",('Back Calculations'!$K$6:$K$816))
EF12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-06-2011",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">30-06-2011",('Back Calculations'!$M$6:$M$816))
EF13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-06-2011",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">30-06-2011",('Back Calculations'!$O$6:$O$816))
EF14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-06-2011",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">30-06-2011",('Back Calculations'!$Q$6:$Q$816))
EF15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-06-2011",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">30-06-2011",('Back Calculations'!$S$6:$S$816))
EF16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-06-2011",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">30-06-2011",('Back Calculations'!$U$6:$U$816))
EF17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-06-2011",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">30-06-2011",('Back Calculations'!$W$6:$W$816))
EF18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-06-2011",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">30-06-2011",('Back Calculations'!$Y$6:$Y$816))
EF19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-06-2011",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">30-06-2011",('Back Calculations'!$AA$6:$AA$816))
EG7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-07-2011",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">31-07-2011",('Back Calculations'!$C$6:$C$816))
EG8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-07-2011",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">31-07-2011",('Back Calculations'!$E$6:$E$816))
EG9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-07-2011",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">31-07-2011",('Back Calculations'!$G$6:$G$816))
EG10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-07-2011",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">31-07-2011",('Back Calculations'!$I$6:$I$816))
EG11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-07-2011",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">31-07-2011",('Back Calculations'!$K$6:$K$816))
EG12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-07-2011",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">31-07-2011",('Back Calculations'!$M$6:$M$816))
EG13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-07-2011",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">31-07-2011",('Back Calculations'!$O$6:$O$816))
EG14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-07-2011",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">31-07-2011",('Back Calculations'!$Q$6:$Q$816))
EG15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-07-2011",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">31-07-2011",('Back Calculations'!$S$6:$S$816))
EG16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-07-2011",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">31-07-2011",('Back Calculations'!$U$6:$U$816))
EG17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-07-2011",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">31-07-2011",('Back Calculations'!$W$6:$W$816))
EG18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-07-2011",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">31-07-2011",('Back Calculations'!$Y$6:$Y$816))
EG19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-07-2011",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">31-07-2011",('Back Calculations'!$AA$6:$AA$816))
EH7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-08-2011",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">31-08-2011",('Back Calculations'!$C$6:$C$816))
EH8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-08-2011",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">31-08-2011",('Back Calculations'!$E$6:$E$816))
EH9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-08-2011",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">31-08-2011",('Back Calculations'!$G$6:$G$816))
EH10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-08-2011",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">31-08-2011",('Back Calculations'!$I$6:$I$816))
EH11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-08-2011",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">31-08-2011",('Back Calculations'!$K$6:$K$816))
EH12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-08-2011",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">31-08-2011",('Back Calculations'!$M$6:$M$816))
EH13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-08-2011",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">31-08-2011",('Back Calculations'!$O$6:$O$816))
EH14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-08-2011",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">31-08-2011",('Back Calculations'!$Q$6:$Q$816))
EH15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-08-2011",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">31-08-2011",('Back Calculations'!$S$6:$S$816))
EH16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-08-2011",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">31-08-2011",('Back Calculations'!$U$6:$U$816))
EH17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-08-2011",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">31-08-2011",('Back Calculations'!$W$6:$W$816))
EH18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-08-2011",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">31-08-2011",('Back Calculations'!$Y$6:$Y$816))
EH19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-08-2011",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">31-08-2011",('Back Calculations'!$AA$6:$AA$816))
EI7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-09-2011",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">30-09-2011",('Back Calculations'!$C$6:$C$816))
EI8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-09-2011",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">30-09-2011",('Back Calculations'!$E$6:$E$816))
EI9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-09-2011",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">30-09-2011",('Back Calculations'!$G$6:$G$816))
EI10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-09-2011",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">30-09-2011",('Back Calculations'!$I$6:$I$816))
EI11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-09-2011",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">30-09-2011",('Back Calculations'!$K$6:$K$816))
EI12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-09-2011",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">30-09-2011",('Back Calculations'!$M$6:$M$816))
EI13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-09-2011",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">30-09-2011",('Back Calculations'!$O$6:$O$816))
EI14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-09-2011",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">30-09-2011",('Back Calculations'!$Q$6:$Q$816))
EI15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-09-2011",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">30-09-2011",('Back Calculations'!$S$6:$S$816))
EI16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-09-2011",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">30-09-2011",('Back Calculations'!$U$6:$U$816))
EI17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-09-2011",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">30-09-2011",('Back Calculations'!$W$6:$W$816))
EI18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-09-2011",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">30-09-2011",('Back Calculations'!$Y$6:$Y$816))
EI19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-09-2011",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">30-09-2011",('Back Calculations'!$AA$6:$AA$816))
EJ7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-10-2011",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">31-10-2011",('Back Calculations'!$C$6:$C$816))
EJ8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-10-2011",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">31-10-2011",('Back Calculations'!$E$6:$E$816))
EJ9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-10-2011",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">31-10-2011",('Back Calculations'!$G$6:$G$816))
EJ10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-10-2011",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">31-10-2011",('Back Calculations'!$I$6:$I$816))
EJ11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-10-2011",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">31-10-2011",('Back Calculations'!$K$6:$K$816))
EJ12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-10-2011",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">31-10-2011",('Back Calculations'!$M$6:$M$816))
EJ13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-10-2011",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">31-10-2011",('Back Calculations'!$O$6:$O$816))
EJ14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-10-2011",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">31-10-2011",('Back Calculations'!$Q$6:$Q$816))
EJ15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-10-2011",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">31-10-2011",('Back Calculations'!$S$6:$S$816))
EJ16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-10-2011",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">31-10-2011",('Back Calculations'!$U$6:$U$816))
EJ17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-10-2011",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">31-10-2011",('Back Calculations'!$W$6:$W$816))
EJ18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-10-2011",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">31-10-2011",('Back Calculations'!$Y$6:$Y$816))
EJ19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-10-2011",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">31-10-2011",('Back Calculations'!$AA$6:$AA$816))
EK7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-11-2011",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">30-11-2011",('Back Calculations'!$C$6:$C$816))
EK8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-11-2011",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">30-11-2011",('Back Calculations'!$E$6:$E$816))
EK9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-11-2011",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">30-11-2011",('Back Calculations'!$G$6:$G$816))
EK10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-11-2011",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">30-11-2011",('Back Calculations'!$I$6:$I$816))
EK11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-11-2011",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">30-11-2011",('Back Calculations'!$K$6:$K$816))
EK12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-11-2011",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">30-11-2011",('Back Calculations'!$M$6:$M$816))
EK13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-11-2011",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">30-11-2011",('Back Calculations'!$O$6:$O$816))
EK14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-11-2011",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">30-11-2011",('Back Calculations'!$Q$6:$Q$816))
EK15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-11-2011",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">30-11-2011",('Back Calculations'!$S$6:$S$816))
EK16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-11-2011",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">30-11-2011",('Back Calculations'!$U$6:$U$816))
EK17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-11-2011",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">30-11-2011",('Back Calculations'!$W$6:$W$816))
EK18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-11-2011",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">30-11-2011",('Back Calculations'!$Y$6:$Y$816))
EK19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-11-2011",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">30-11-2011",('Back Calculations'!$AA$6:$AA$816))
EL7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-12-2011",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">31-12-2011",('Back Calculations'!$C$6:$C$816))
EL8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-12-2011",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">31-12-2011",('Back Calculations'!$E$6:$E$816))
EL9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-12-2011",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">31-12-2011",('Back Calculations'!$G$6:$G$816))
EL10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-12-2011",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">31-12-2011",('Back Calculations'!$I$6:$I$816))
EL11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-12-2011",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">31-12-2011",('Back Calculations'!$K$6:$K$816))
EL12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-12-2011",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">31-12-2011",('Back Calculations'!$M$6:$M$816))
EL13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-12-2011",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">31-12-2011",('Back Calculations'!$O$6:$O$816))
EL14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-12-2011",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">31-12-2011",('Back Calculations'!$Q$6:$Q$816))
EL15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-12-2011",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">31-12-2011",('Back Calculations'!$S$6:$S$816))
EL16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-12-2011",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">31-12-2011",('Back Calculations'!$U$6:$U$816))
EL17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-12-2011",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">31-12-2011",('Back Calculations'!$W$6:$W$816))
EL18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-12-2011",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">31-12-2011",('Back Calculations'!$Y$6:$Y$816))
EL19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-12-2011",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">31-12-2011",('Back Calculations'!$AA$6:$AA$816))
EM7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-01-2012",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">31-01-2012",('Back Calculations'!$C$6:$C$816))
EM8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-01-2012",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">31-01-2012",('Back Calculations'!$E$6:$E$816))
EM9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-01-2012",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">31-01-2012",('Back Calculations'!$G$6:$G$816))
EM10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-01-2012",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">31-01-2012",('Back Calculations'!$I$6:$I$816))
EM11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-01-2012",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">31-01-2012",('Back Calculations'!$K$6:$K$816))
EM12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-01-2012",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">31-01-2012",('Back Calculations'!$M$6:$M$816))
EM13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-01-2012",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">31-01-2012",('Back Calculations'!$O$6:$O$816))
EM14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-01-2012",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">31-01-2012",('Back Calculations'!$Q$6:$Q$816))
EM15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-01-2012",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">31-01-2012",('Back Calculations'!$S$6:$S$816))
EM16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-01-2012",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">31-01-2012",('Back Calculations'!$U$6:$U$816))
EM17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-01-2012",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">31-01-2012",('Back Calculations'!$W$6:$W$816))
EM18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-01-2012",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">31-01-2012",('Back Calculations'!$Y$6:$Y$816))
EM19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-01-2012",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">31-01-2012",('Back Calculations'!$AA$6:$AA$816))
EN7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-02-2012",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">28-02-2012",('Back Calculations'!$C$6:$C$816))
EN8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-02-2012",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">28-02-2012",('Back Calculations'!$E$6:$E$816))
EN9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-02-2012",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">28-02-2012",('Back Calculations'!$G$6:$G$816))
EN10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-02-2012",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">28-02-2012",('Back Calculations'!$I$6:$I$816))
EN11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-02-2012",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">28-02-2012",('Back Calculations'!$K$6:$K$816))
EN12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-02-2012",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">28-02-2012",('Back Calculations'!$M$6:$M$816))
EN13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-02-2012",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">28-02-2012",('Back Calculations'!$O$6:$O$816))
EN14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-02-2012",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">28-02-2012",('Back Calculations'!$Q$6:$Q$816))
EN15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-02-2012",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">28-02-2012",('Back Calculations'!$S$6:$S$816))
EN16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-02-2012",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">28-02-2012",('Back Calculations'!$U$6:$U$816))
EN17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-02-2012",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">28-02-2012",('Back Calculations'!$W$6:$W$816))
EN18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-02-2012",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">28-02-2012",('Back Calculations'!$Y$6:$Y$816))
EN19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-02-2012",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">28-02-2012",('Back Calculations'!$AA$6:$AA$816))
EO7	=SUMIF('Back Calculations'!$B$6:$B$816,">=1-03-2012",('Back Calculations'!$C$6:$C$816))-SUMIF('Back Calculations'!$B$6:$B$816,">31-3-2012",('Back Calculations'!$C$6:$C$816))
EO8	=SUMIF('Back Calculations'!$D$6:$D$816,">=1-03-2012",('Back Calculations'!$E$6:$E$816))-SUMIF('Back Calculations'!$D$6:$D$816,">31-3-2012",('Back Calculations'!$E$6:$E$816))
EO9	=SUMIF('Back Calculations'!$F$6:$F$816,">=1-03-2012",('Back Calculations'!$G$6:$G$816))-SUMIF('Back Calculations'!$F$6:$F$816,">31-3-2012",('Back Calculations'!$G$6:$G$816))
EO10	=SUMIF('Back Calculations'!$H$6:$H$816,">=1-03-2012",('Back Calculations'!$I$6:$I$816))-SUMIF('Back Calculations'!$H$6:$H$816,">31-3-2012",('Back Calculations'!$I$6:$I$816))
EO11	=SUMIF('Back Calculations'!$J$6:$J$816,">=1-03-2012",('Back Calculations'!$K$6:$K$816))-SUMIF('Back Calculations'!$J$6:$J$816,">31-3-2012",('Back Calculations'!$K$6:$K$816))
EO12	=SUMIF('Back Calculations'!$L$6:$L$816,">=1-03-2012",('Back Calculations'!$M$6:$M$816))-SUMIF('Back Calculations'!$L$6:$L$816,">31-3-2012",('Back Calculations'!$M$6:$M$816))
EO13	=SUMIF('Back Calculations'!$N$6:$N$816,">=1-03-2012",('Back Calculations'!$O$6:$O$816))-SUMIF('Back Calculations'!$N$6:$N$816,">31-3-2012",('Back Calculations'!$O$6:$O$816))
EO14	=SUMIF('Back Calculations'!$P$6:$P$816,">=1-03-2012",('Back Calculations'!$Q$6:$Q$816))-SUMIF('Back Calculations'!$P$6:$P$816,">31-3-2012",('Back Calculations'!$Q$6:$Q$816))
EO15	=SUMIF('Back Calculations'!$R$6:$R$816,">=1-03-2012",('Back Calculations'!$S$6:$S$816))-SUMIF('Back Calculations'!$R$6:$R$816,">31-3-2012",('Back Calculations'!$S$6:$S$816))
EO16	=SUMIF('Back Calculations'!$T$6:$T$816,">=1-03-2012",('Back Calculations'!$U$6:$U$816))-SUMIF('Back Calculations'!$T$6:$T$816,">31-3-2012",('Back Calculations'!$U$6:$U$816))
EO17	=SUMIF('Back Calculations'!$V$6:$V$816,">=1-03-2012",('Back Calculations'!$W$6:$W$816))-SUMIF('Back Calculations'!$V$6:$V$816,">31-3-2012",('Back Calculations'!$W$6:$W$816))
EO18	=SUMIF('Back Calculations'!$X$6:$X$816,">=1-03-2012",('Back Calculations'!$Y$6:$Y$816))-SUMIF('Back Calculations'!$X$6:$X$816,">31-3-2012",('Back Calculations'!$Y$6:$Y$816))
EO19	=SUMIF('Back Calculations'!$Z$6:$Z$816,">=1-03-2012",('Back Calculations'!$AA$6:$AA$816))-SUMIF('Back Calculations'!$Z$6:$Z$816,">31-3-2012",('Back Calculations'!$AA$6:$AA$816))
EP7	=SUM(ED7:EO7)
EP8	=SUM(ED8:EO8)
EP9	=SUM(ED9:EO9)
EP10	=SUM(ED10:EO10)
EP11	=SUM(ED11:EO11)
EP12	=SUM(ED12:EO12)
EP13	=SUM(ED13:EO13)
EP14	=SUM(ED14:EO14)
EP15	=SUM(ED15:EO15)
EP16	=SUM(ED16:EO16)
EP17	=SUM(ED17:EO17)
EP18	=SUM(ED18:EO18)
EP19	=SUM(ED19:EO19)

 

[RIZVI]

While Mr.Excel forum has been very helpful in my each and every query, I do not understand why there is not much help forthcoming on my this particular query.

I on my own have been trying various metods, like probability and other mathmetical tools I am not getting the desied results.

I am sure there must be a way around. I await help on this query.

RGDS,

Rizvi.M.H.