# Analysis using counts of goods between certain dates

#### xxsalahxx

##### Active Member
Hello Is it possible to have a piece of analysis for counting how many references fall between the dates 01/01/2013 to 31/01/2013. Then 01/02/2013 to 29/02/2013?
I have 2 columns as you can see below and have approx 5000 rows of data.
January should total up to 6 from my example below and february should total up to 3.
This is from sheet one and im trying to calculate this on sheet 2 if possible?
Thanking you in advance for any help anyone can give to me.

 Ref Date PP0001 01/01/2013 PP0002 01/01/2013 PP0003 09/01/2013 PP0004 28/01/2013 PP0005 20/02/2013 PP0006 PP0007 19/01/2013 PP0008 23/02/2013 PP0009 PP0010 04/02/2013 PP0011 03/01/2013

<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><TBODY>
</TBODY>

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Hello Is it possible to have a piece of analysis for counting how many references fall between the dates 01/01/2013 to 31/01/2013. Then 01/02/2013 to 29/02/2013?
I have 2 columns as you can see below and have approx 5000 rows of data.
January should total up to 6 from my example below and february should total up to 3.
This is from sheet one and im trying to calculate this on sheet 2 if possible?
Thanking you in advance for any help anyone can give to me.

 Ref Date PP0001 01/01/2013 PP0002 01/01/2013 PP0003 09/01/2013 PP0004 28/01/2013 PP0005 20/02/2013 PP0006 PP0007 19/01/2013 PP0008 23/02/2013 PP0009 PP0010 04/02/2013 PP0011 03/01/2013

<TBODY>
</TBODY>

Try Pivot Table.

Is there any analysis apart from using pivot tables as this spreadsheet needs to be self analysing for other users? Thank you.

Is there any analysis apart from using pivot tables as this spreadsheet needs to be self analysing for other users? Thank you.

Excel 2010
ABCDEF
1RefDateJanuaryFebruary
2PP00011/1/201363
3PP00021/1/2013
4PP00031/9/2013
5PP00041/28/2013
6PP00052/20/2013
7PP0006
8PP00071/19/2013
9PP00082/23/2013
10PP00092/4/2013
11PP00104/2/2013
12PP00111/3/2013
Sheet2
Cell Formulas
RangeFormula
E2=SUMPRODUCT(--(MONTH(\$B\$2:\$B\$13)=MONTH(E\$1)),--(\$B\$2:\$B\$13<>""))

Replies
0
Views
168
Replies
9
Views
684
Replies
1
Views
475
Replies
5
Views
492
Replies
10
Views
638

1,196,134
Messages
6,013,642
Members
441,777
Latest member

### 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?

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