Avg a range of cells excluding text found in other cells

**excelneub** · 07-17-2014, 07:08 AM

What I want to do is Average out a range of cells "F4:F343". That's the easy part =average(F4:F343). However I want to exclude any numbers for that average if data in coloumn "Q" = "FMC"

Would that look anything like:
=average(F4:F343)/countif(Q4:Q343, "<>FMC")
I'm also displaying it as minutes in a day so i added *24*60 to the end of the formula and formatted to Number/.00. I've entered the formula and it will calculate but when i enter FMC to the appropriate area the average wont change.

**zbor** · 07-17-2014, 07:15 AM

With XL2007 and newer you can use AVERAGEIF

Formula:

Please Login or Register  to view this content.

**excelneub** · 07-17-2014, 07:20 AM

Originally Posted by zbor

With XL2007 and newer you can use AVERAGEIF

Formula:

Please Login or Register  to view this content.

Thank you that worked very well. Now if i can get my formatting down ill be all set.

Avg a range of cells excluding text found in other cells

LinkBack

Thread Tools

Rate This Thread

Display

Avg a range of cells excluding text found in other cells

Re: Avg a range of cells excluding text found in other cells

Re: Avg a range of cells excluding text found in other cells

Thread Information

Users Browsing this Thread

Similar Threads

Formula needed for dividing 2 sets of cells and excluding adjacent text cells

[SOLVED] IF range of cells contains string of text, return contents of cell where string is found

Excluding blank cells from a range of data

[SOLVED] Min of range of cells excluding text.

INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell

Bookmarks

Bookmarks

Posting Permissions