Hi all

I'm using this formula:

=SUM(VLOOKUP((B82&C82),wkone,4,0),VLOOKUP((B82&C82),wktwo,4,0),VLOOKUP((B82&C82),wkthree,4,0),VLOOKUP((B82&C82),wkfour,4,0),VLOOKUP((B82&C82),wkfive,4,0))

The VLOOKUP function is working fine when there are numerical values in the cells I'm referencing but when there is text in any of the cells, I get a #VALUE error.

I've done a little research and apparently the SUM function is meant to help avoid those errors as opposed to using a simple arithmetic arguments (=a2+b2) but I can't find anything about the use of functions within the sum itself.

I need the formula to ignore text entries. How can I go about doing that?

Appreciate any help!

Cheers