Finding avg weight of varying no. of sales designs

  • Hi!


    I have a no. of sales designs whose no. keeps varying in my database. I want to find out the Avg weight of sales of each design and compare it with the sales of that design by each individual sales person, without sorting out the data in the col.


    For example, sales person A sells 20 pieces of design 4 and B sells 10, so my result should say 15 in front of col. for design 4 for both A & B


    Sample file with sample result attached


    My data is as follows:
    [TABLE="width: 203"]

    [tr]


    [td]

    Sales Person

    [/td]


    [TD="align: right"]Design no.
    [/TD]
    [TD="align: right"]Pieces sold
    [/TD]

    [/tr]


    [tr]


    [td]

    B

    [/td]


    [TD="align: right"]4
    [/TD]
    [TD="align: right"]10
    [/TD]

    [/tr]


    [tr]


    [td]

    C

    [/td]


    [TD="align: right"]3
    [/TD]
    [TD="align: right"]11
    [/TD]

    [/tr]


    [tr]


    [td]

    D

    [/td]


    [TD="align: right"]4
    [/TD]
    [TD="align: right"]13
    [/TD]

    [/tr]


    [tr]


    [td]

    E

    [/td]


    [TD="align: right"]2
    [/TD]
    [TD="align: right"]18
    [/TD]

    [/tr]


    [tr]


    [td]

    F

    [/td]


    [TD="align: right"]3
    [/TD]
    [TD="align: right"]3
    [/TD]

    [/tr]


    [tr]


    [td]

    G

    [/td]


    [TD="align: right"]4
    [/TD]
    [TD="align: right"]7
    [/TD]

    [/tr]


    [tr]


    [td]

    H

    [/td]


    [TD="align: right"]1
    [/TD]
    [TD="align: right"]6
    [/TD]

    [/tr]


    [tr]


    [td]

    I

    [/td]


    [TD="align: right"]5
    [/TD]
    [TD="align: right"]3
    [/TD]

    [/tr]


    [tr]


    [td]

    J

    [/td]


    [TD="align: right"]1
    [/TD]
    [TD="align: right"]1
    [/TD]

    [/tr]


    [tr]


    [td]

    K

    [/td]


    [TD="align: right"]1
    [/TD]
    [TD="align: right"]5
    [/TD]

    [/tr]


    [tr]


    [td]

    L

    [/td]


    [TD="align: right"]2
    [/TD]
    [TD="align: right"]19
    [/TD]

    [/tr]


    [tr]


    [td]

    M

    [/td]


    [TD="align: right"]1
    [/TD]
    [TD="align: right"]7
    [/TD]

    [/tr]


    [tr]


    [td]

    N

    [/td]


    [TD="align: right"]5
    [/TD]
    [TD="align: right"]12
    [/TD]

    [/tr]


    [tr]


    [td]

    O

    [/td]


    [TD="align: right"]2
    [/TD]
    [TD="align: right"]4
    [/TD]

    [/tr]


    [tr]


    [td]

    P

    [/td]


    [TD="align: right"]2
    [/TD]
    [TD="align: right"]9
    [/TD]

    [/tr]


    [/TABLE]

  • Re: Finding avg weight of varying no. of sales designs


    Try:


    [COLOR="#0000FF"]=AVERAGEIF($B$2:$B$17,$B2,$C$2:$C$17)[/COLOR]


    copied down

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!