Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to calculate the average sales price

  1. #1
    New Member
    Join Date
    Aug 2009
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to calculate the average sales price

    I have a list of 5 buildings each with different unit counts, and an average price sold for each building. How can I get the average price of all units sold?

    A B
    312 $1000
    54 $1010
    35 $1835
    32 $1028
    53 $1937

  2. #2
    Board Regular
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,720
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to calculate the average sales price

    =sumproduct(a1:a5,b1:b5)/sum(a1:a5)
    Neil

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •