Hi all,
Apologies if this is a really simple one, but cannot think where to start googling and i'm going round in circles.
I have a worksheet with raw data in that I use to record the number of letter drops I am sending for my business. An example of the simple worksheet is below:
![](/board/proxy.php?image=https%3A%2F%2Fthumb.ibb.co%2Fi4hqDy%2FCapture_1.png&hash=07db84547fa4eff4cf32dd1b80411b13)
Now in the same document, I have several other worksheets for each month of the year (see below). What i want to do is add a formula into the monthly tabs to populate the totals for each day, from looking at the raw data spreadsheet.
![](/board/proxy.php?image=https%3A%2F%2Fthumb.ibb.co%2FnBH46J%2FCapture_2.png&hash=93853c62a4e9e759ddaf7a625ae8a808)
What is the easiest way of adding a formula to look at the date in the raw data and return in the total column a count of the number of entries, under each option for that given day, then a total number of letters (again for the given day).
I cannot work out where to start!!!!
Apologies if this is a really simple one, but cannot think where to start googling and i'm going round in circles.
I have a worksheet with raw data in that I use to record the number of letter drops I am sending for my business. An example of the simple worksheet is below:
![](/board/proxy.php?image=https%3A%2F%2Fthumb.ibb.co%2Fi4hqDy%2FCapture_1.png&hash=07db84547fa4eff4cf32dd1b80411b13)
Now in the same document, I have several other worksheets for each month of the year (see below). What i want to do is add a formula into the monthly tabs to populate the totals for each day, from looking at the raw data spreadsheet.
![](/board/proxy.php?image=https%3A%2F%2Fthumb.ibb.co%2FnBH46J%2FCapture_2.png&hash=93853c62a4e9e759ddaf7a625ae8a808)
What is the easiest way of adding a formula to look at the date in the raw data and return in the total column a count of the number of entries, under each option for that given day, then a total number of letters (again for the given day).
I cannot work out where to start!!!!