Results 1 to 9 of 9

Solving AVERAGEIFS where one column must equal another column, please help!

Threaded View

  1. #1
    Registered User
    Join Date
    01-22-2021
    Location
    London
    MS-Off Ver
    2019
    Posts
    5

    Exclamation Solving AVERAGEIFS where one column must equal another column, please help!

    I have a set of data like that shown below. I am trying to do an average ifs for this data to average the number of trips, the amount of vehicles must be bigger than 0 AND the number of vehicles must equal the amount of people. what is the formula in order to do this?

    I am able to write the formula for if greater than zero, but I am having difficulty finding out how to say that the value in one column (vehicles) must equal the one in the next (people)
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. AVERAGEIFS AGE & COUNTIFS Column C contains Y OR column D contains Y
    By Jatzbiscuits in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-10-2020, 01:44 AM
  2. Adding multiple values in one column to equal to one number in another column.
    By Accountant0607 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2014, 09:24 AM
  3. Replies: 1
    Last Post: 11-24-2013, 01:51 AM
  4. Replies: 4
    Last Post: 05-08-2013, 08:33 AM
  5. Replies: 11
    Last Post: 01-18-2013, 04:05 PM
  6. Average range of cells in column if values in adjacent column are equal
    By RyNye in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 10:12 AM
  7. Replies: 2
    Last Post: 08-04-2006, 03:00 PM

Tags for this Thread

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