Formula help please

[djgreen27]

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:



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.



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!!!!

 

[mole999]

probably easiest is a pivot table from the select data. providing the date is a real date (for simplicity)

 

[onlyadrafter]

Hello,

For a formula version, with the following assumptions, the raw data is in cols A:D and the other table starts in F1.

In the cell under Total for option 1 enter

=SUMPRODUCT(--($A$2:$A$5=$F3)*(--($B$2:$B$5=G$1))*$D$2:$D$5)

and in the cell under Total Letters for option 1 enter

=SUMIF($A$2:$A$5,$F3,$D$2:$D$5)

then copy these down as far as required, then copy the two columns over as many times as required.

Not sure what results you are expecting.

Are these correct? Perhaps you can post what results you expect to see.