I am in need of help with an if:then statement.
The original statement
=IF(B41:B430="Total",IF($K$1="",$J$1,$K$1),"")
worked great until I discovered that there might be data in M that meets this condition.
Is there a may to modify the above so that it would look in M as well as J and K for the result?
thanks for any input
The original statement
=IF(B41:B430="Total",IF($K$1="",$J$1,$K$1),"")
worked great until I discovered that there might be data in M that meets this condition.
Is there a may to modify the above so that it would look in M as well as J and K for the result?
thanks for any input