SUMIF not working

Markus Teucsich

Hi, I am trying to SUMIF to a range of VLOOKUP's where some of them result in #NO MATCH. And the SUMIF always gives me a #NO MATCH error.

Can someone explain to me why this is not working and if there is a workaround.

Thanks!!

Paul Newcome

You will need to remove the error from the VLOOKUPs by wrapping them in an IFERROR.

=IFERROR(VLOOKUP(.....................), 0)

Paul Newcome

You will need to remove the error from the VLOOKUPs by wrapping them in an IFERROR.

=IFERROR(VLOOKUP(.....................), 0)

Markus Teucsich

Thank you Paul for your quick feedback. That worked well, it would be great if such limits of functions are mentioned at the learning center page each function.

Paul Newcome

The IFERROR page uses a VLOOKUP as an example. Or are you meaning that it specifies that a range containing an error will have that error pull through into a formula referencing that range?

Markus Teucsich

Yeah, I mean to mention that if a range contains an error will that error pull through into a formula referencing that range - that could like a general note at every learning center page of each function.

Thanks,

Markus

Paul Newcome

Yeah. That is true for all functions. Some errors pull through and others will just break everything and cause a #BLOCKED error.