Calculate weighted average based on a date

[danallamas]

I need to be able to calculate the weighted average per date. This is the weighted average calculation =SUMPRODUCT(q1 score, q1 count)/SUM(q1 count)
The criterion is the date. I have attached a sample workbook. The data is in another sheet (Raw)

[6StringJazzer]

What are you using as a weight? Your formula for Volume doesn't make sense.

Please Login or Register  to view this content.

Raw$C:$I contains the following columns:

Please Login or Register  to view this content.

So it is counting the number of times the date in A2 appears in any of those columns. The only column containing a date is C. Also COUNTIF can be used instead of COUNTIFS if all you are doing is counting dates. So I am thinking you meant to do something different with this formula.

Are the numbers in Raw!I (Q1) supposed to be the volume? If so then I think you mean for that formula to be

Please Login or Register  to view this content.

Once we understand what's going on there, we can talk about a weighted average by date.