Thread: Formula to handle more than seven possible errors

In the attached, I have a file that will have changing data populated to columns B through Q. In column R I need to return if "Review" if all columns C through G are > 0 and at least one column H through Q is > 0.

You can see a formula in column R that attempts this.

The populated data comes from a cross query in Access to another file and I use HLookups to pull in data to this file. Because the data comes from a cross query, at different times, columns H through Q will not always be exported from Access (if a no loans in the subset has one of these documents). Due to this, all columns H through Q can possibly return error messages such as the current error messages in Columns I, K, O & Q.

Can someone please help me build a formula in column R that will do what the current formula in column R is trying, but also flexible to an error message being presented in any of the columns in H through Q?

Thanks in advance.

Try this in R2 and copy down:

=IF(SUMIF($N2:$Q2,"<>#N/A"),"Review","Not Ready")

This assumes all the possible relevant values will be numeric, text values will not be counted.