Hi Excel Forum Members
I've been struggling with the following problem.

i'm trying to figure out formulas that will
1: count how many times a date appears is a set of numbers
2: add together the values associated with the date

I hope i've explained it. Ive attached an example and also the table i'm trying to complete. I have manually completed the outcome table but i'm after formulas that will do this work automatically. it is also possible to have h6 and i6 reference g6?

Thank you in advance
Callum