Results 1 to 6 of 6

Averageif statement for Excel 2003

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2011
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    12

    Averageif statement for Excel 2003

    Hi, I am looking to make an averageif function in excel 2003 that would average only the numbers that meet my criteria, but I cant figure out how to do it. I made an example table that I attached. Basically i want a function that will average the numbers (column B) only if they match the criteria (column A). Please help! Thank you in advance!Example.xls
    Last edited by chitownsox14; 07-07-2012 at 01:26 PM.

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