Is there a formula that will check 2 columns in the same row. I would like to
have 1 cell that will keep a running total if columns D or Column E has the
words "Error". There are some cases where both columns will have this word
but I would only like the number to be counted once.

I think that there is a very simple formula for it, but I forget it at the
moment. Could someone please help

Thanks