Count SUMPRODUCT Members / Average of SUMPRODUCT

hi,

I have a sumproduct formula, I am trying to divide the output by the number of members used in the calculation:

This is my data set

4/10/2014 102.621 4/10/2014 99.514 4/8/2014 106.14 4/8/2014 105.4
4/9/2014 102.328 4/9/2014 99.386 4/2/2014 105.873 4/7/2014 103.6
4/8/2014 102.088 4/8/2014 98.795 3/17/2014 105.586 4/3/2014 103.95
4/7/2014 102.017 4/7/2014 98.588 3/5/2014 105.845 3/31/2014 103.45
4/4/2014 101.88 4/4/2014 98.59 2/10/2014 105.624 3/27/2014 103.73
4/3/2014 101.445 4/3/2014 98.167 2/5/2014 105.18 3/26/2014 103.223
4/2/2014 101.465 4/2/2014 98.221 1/22/2014 105.431 3/25/2014 102.74
4/1/2014 101.666 4/1/2014 98.245 1/17/2014 105.728 3/24/2014 102.4
3/31/2014 101.35 3/31/2014 98.056 12/11/2013 106.662 3/21/2014 102.384


and currently this is the output:

3/31/2014 7302.468
4/1/2014 7725.832
4/2/2014 7567.259
4/3/2014 7632.326
4/4/2014 7171.149
4/7/2014 7071.164
4/8/2014 7394.095
4/9/2014 7097.243
4/10/2014 6589.941

my sumproduct function is adding up all items that fall on that date which is fine, but i would love to calculate an average so divide by the number of items that were used in the calculation, is that possible?

=SUMPRODUCT(--(A1:G9=A11),(B1:H9))

Many thanks

Shin

nailed it,

Is it possible to take this 1 step further:

On top of each data set, I have a name on the Date (Col A) and a number in Col B.


Instead of counting the members, would it be possible to instead of dividing by the number of the instances, but adding up the top numbers (Col B) highlighted in Yellow

please see attached attached

http://www.4shared.com/file/jdylgin7ce/Book1.html

The boxes highlighted in colors is what i am trying to achieve.

Many Thanks

i know i am close, i think all i need a is a sumproduct mixed with index match with an offset