# Calculate weighted average for values between two date ranges.

1. ## Calculate weighted average for values between two date ranges.

Hi all,

A B C
2 1/06/12 200 5
3 5/06/12 300 6
4 10/06/12 600 4

I have a data set representative of the above (although thousands of rows) and need to calculate a weighted average grade for those values which have a date >= 1/06/12 and <= 6/06/12. Any thoughts on how I can do this?

2. ## Re: Calculate weighted average for values between two date ranges.

Well, I am not well versed in weighted averages, but I would think we would also need some information on how the weighting is supposed to occur...maybe a sample workbook would help..

3. ## Re: Calculate weighted average for values between two date ranges.

Sure thing, see the attached which shows the calculation of a weighted average. Now I just need to be able to specify a data range.

Thanks.

Chan

4. ## Re: Calculate weighted average for values between two date ranges.

And you want this where, compared against what?.....your sample DOES give the weighted average, what it does NOT do, is show what you expect to see against what base date...it can not, as there is no base data....What have you got, what do you expect to see from a few samples...hopefuly a few different dates, so we can make sure the formulas are working right
(Must be be me, but I have noticed that tonight, very few people actually willing to supply workbooks with relevant info...)

5. ## Re: Calculate weighted average for values between two date ranges.

No problems at all and truly appreciate your assistance on this. See the attached

6. ## Re: Calculate weighted average for values between two date ranges.

Okay, try this -
In H1 : Start Date
In I1 : Last Date
then this :
Formula:
`Please Login or Register  to view this content.`

(I've put this in J2 in the attachment, But you could put it in G2)

Note - the formula in D49 is simply a manual check, delete without worry

Hope this helps

7. ## Re: Calculate weighted average for values between two date ranges.

I really struggled trying to figure how to make my formula work; in the end, I found this thread and it solved my problem. Thank you very much dredwolf.

Originally Posted by dredwolf

Hope this helps

8. ## Re: Calculate weighted average for values between two date ranges.

You are very welcome !

There are currently 1 users browsing this thread. (0 members and 1 guests)