Results 1 to 4 of 4

Sumproduct & Average

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2006
    Posts
    62

    Sumproduct & Average

    Ok so I have searched and haven't found anything, so I am asking for your great help!

    I have 3 columns: months, city & name with hundreds of info. Here's a brief example

    months City name
    5 NY BOB
    15 NY BOB

    I want to find the average months that Bob, from NY has taken. So I used this fromula

    =SUMPRODUCT((B2:B14="NY")*(C2:C14="BOB")*(A2:A14))/SUMPRODUCT((B2:B14="NY")*(C2:C14="BOB"))

    Where the first fromula figures out the sum and the 2nd figures out the count. My question is there an easier formula to use where you can find the averages w/ using the Sumproduct? I'll attach the example.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1