Sum/Count/Average based on multi criteria in table, skip duplicates when not needed.

Hi,

First of all: thanks for taking the time to read my post

I've tried numerous of formulas from this forum, but unfortunately I haven't been succesful...

I have a table with:

Things---------Date------------Amount-----Day of the week
Thing 01-----10-08-2015----------5---------------Mo
Thing 02-----10-08-2015----------2---------------Mo
Thing 01-----10-08-2015----------3---------------Mo
Thing 03-----10-08-2015----------2---------------Mo
Thing 01-----17-08-2015----------2---------------Mo
Thing 03-----17-08-2015----------1---------------Mo
Thing 01-----17-08-2015----------6---------------Mo
Thing 01-----24-08-2015----------1---------------Mo
Thing 03-----24-08-2015----------4---------------Mo
Thing 01-----11-08-2015----------3---------------Tu
Thing 02-----11-08-2015----------4---------------Tu
Thing 01-----11-08-2015----------1---------------Tu

Etc.

The table is about 30.000 rows big and Things run up to 100 different names.

My variables are; Day of the week & Things

I would like to calculate how many Mondays (or Tuesdays, Wednesdays as in my table) per unique date I've got. In this case: 3
Also, I'd like to know the sum of each Monday per Thing. So the correct answer would be:
Thing 01 - 17
Thing 02 - 2
Thing 03 - 7
And with these I could calculate the average per Thing per Monday (or Tuesdays, Wednesdays as in my table).

When possible, a option to select Multi Things when needed.

Many thanks in advance..!

TestFile-1(PT calc field sol).xlsx
Here is a possible solution that uses a Pivot Table with a calculated field, also notice that it employees a helper column (count) with the formula:

Please Login or Register  to view this content.

Let me know if you have any questions.

@HangMan

Thanks for your quick reply..

I'm not able to test your solution right now (not at work), so please correct me if I'm wrong:

Doesn't the last part of your formula (,Tabel1[Date],"10/8/15") mean that I have to specify each date seperately..? As far as my knowledge goes this part would give me a result of 2 for "Thing 01" (with Day of the week value "Mo" on that specific date "18-08-2015").
The list can go up to a year of data (i.e. 365 different days), so that would be kind of problematic..

@JeteMC
Working with Pivot Tables is my Plan B, mos def..! But eventually there are some more criteria I'll have to fit in the formula I'm looking for, and because of that I'mm looking for a formula first.