Expected Figures

R

RIZVI

Active Member
Joined
Jan 1, 2011
Messages
295
Office Version
  1. 2010
Platform
  1. Windows
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.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Sort by date Sort by votes
RIZVI said:
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???
Click to expand...

While PivotTable may not give you the numbers you are seeking, it will show you a trend (if there is one).
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
Excel Workbook
EDEEEFEGEHEIEJEKELEMENEOEP
3Apr-11May-11Jun-11Jul-11Aug-11Sep-11Oct-11Nov-11Dec-11Jan-12Feb-12Mar-12Total Sales
4
5
6
7003572325028511447800000039811
800048650079300000012795
9013788000078280000021616
100373000041500000007880
11001328800000000013288
120000058000000005800
130071000000000007100
144658000236092469074290000060386
15699423763625800037050000040720
1600056500000000565
1700006250940000000015650
180062270000000006227
190394000000000003940
Sales & Purchases
Excel 2007
Cell Formulas
RangeFormula
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)
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Solved
Conditional formatting of invoice lists of varying lengths for presence of a given string
5 6 7
Replies
65
Views
5K
Alex Blakenburg
A
P
  • Question Question
Auto Populate one table from another
2
Replies
12
Views
6K
excel_learnerz
E
R
  • Question Question
Sales Forecast
2
Replies
13
Views
1K
AlphaFrog
AlphaFrog
R
  • Question Question
Expected Min and Max Sales in Current Month
Replies
5
Views
387
RIZVI
R
T
  • Question Question
Analyzing eCommerce Sales and Forecasting Demand
Replies
4
Views
712
oldbrewer
O

Forum statistics

Threads
1,225,071
Messages
6,182,687
Members
453,132
Latest member
nsnodgrass73

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top