Hello All,

Can someone please tell me how I can find the MAX value in columns where there are errors (#N/A)?

I have two columns and I need the third column to return the MAX value it can find from columns A & B.

Sample:
$1.50 $2.50
$3.50 $2.00
#N/A $3.50
#N/A $1.50

Unfortunately, I am not sure what the equivalent of aggregate function is in Google Sheets. I tinkered around the MAXIFS function but its not working. I only have two columns for the data and the third column is where I want to get the result.