|
|
#3
09-21-2017, 12:39 AM
|
||||
|
||||
Using double quotes returns text strings instead of numbers
=IF(A1="","",IF(OR(A1="y",A1="NA"),5,0)) To exclude the "" strings from the average use the AVERAGEIF function excluding null strings <>""""
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
|
Need Help w/Formula
|
OSCAR MARTINEZ | Excel | 1 | 09-28-2013 05:39 AM |
|
formula help
|
excelledsoftware | Excel | 8 | 03-25-2012 08:49 AM |
|
Help with formula please.
|
AndrewSE | Excel | 3 | 04-05-2011 08:50 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode