Formula Below
=IF($B17<>$B18,SUMIF($B$12:$B$241,$B17,$F$12:$F$241),"")
Can this be changed to ignore #n/a in column B?
Formula Below
=IF($B17<>$B18,SUMIF($B$12:$B$241,$B17,$F$12:$F$241),"")
Can this be changed to ignore #n/a in column B?
Re: Ignoring #N/A in complex formula
Personally I would change the formula which is resulting in the #N/A error. You can use the isna() function to determine whether a calculation has resulted in an #N/A error and output a blank cell. Something like this:
Don’t have an account yet? Register yourself now and be a part of our community!