avergaes over multiple cells references

[laifc]

HI All,
I'm stuck on how to do this.

I need to work out the average number of quotes per Ref number, however the data is segmented into rows for each time a quote is done and recorded with the Ref Number and then a quote reference

I need to someway to consolidate the number of "quotes" per ref number to then be able to work out the Average of quotes per booking.

For example

Ref Number Quote
ghtyf 1
ghtyf 1
hyfgb 1
jybbf 1
jybbf 1
jybbf 1
jybbf 1


I would do it manually but I have a few thousand lines of data.

Any help would be great .. thanks in advance.
L

[AliGW]

Welcome to the forum.

Your sample data is not satisfactory. Please manually add your expected outcomes and post again.

[laifc]

Thanks AliGW,

I have re attched does this help ?
Cheers
L

[AliGW]

This has nothing to do with averages!

In E2 drag copied down:

=COUNTIF($A$2:$A$12,D2)

or this, depending on what you want:

=SUMIF($A$2:$A$12,D2,$B$2:$B$12)