Hi Admin,

Thanks for you help again,

I'm pretty sure this returns the average per day, doesn't it? I can work with this, but was actually looking for a formula that:

- Looks for all the criteria
- Then checks if there are double dates (there will be a max of 2, based on the other criteria)
- Take the averages of those double records (max 2)
- Then sums up all of it

ie, Following records:

Date - Driver - Sector - Thread - Pax

1/1/2015 - John - 1 - A - 12
1/1/2015 - John - 2 - A - 13
16/1/2015 - John - 1 - B - 12
16/1/2015 - John - 2 - B - 14
2/2/2015 - John - 1 - C - 16
2/3/2015 - John - 1 - C - 17
2/4/2015 - John - 1 - C - 24

So for criteria: Driver John, between 1/01/2015 and 15/02/2015, Minus excluded threads(D or whatever) will return the sum of following:

1/1/2015 - John - 1 - A - 12
1/1/2015 - John - 2 - A - 13
16/1/2015 - John - 1 - B - 12
16/1/2015 - John - 2 - B - 14
2/2/2015 - John - 1 - C - 16

And I want the formula to average the doubles, per date, before summing them. So average these:

1/1/2015 - John - 1 - A - 12
1/1/2015 - John - 2 - A - 13

and these

16/1/2015 - John - 1 - B - 12
16/1/2015 - John - 2 - B - 14

and then sum those averages with

2/2/2015 - John - 1 - C - 16


Hope this is clear and hope it's possibel :D

Thanks,