iferror/sumifs

[Rogerisit]

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'}span.s1 {color: #006107}span.s2 {color: #0057d6}span.s3 {color: #ab30d6}</style>=IFERROR(SUMIFS('1'!H:H,'1'!D:D,Stage!B9),IFERROR(SUMIFS('2'!H:H,'2'!D:D,Stage!B9),))

Hi all!
Thanks in advance for any help.

The above formula doesn't work, can you help me pls. I can get the value from sheet "1", but it wont move on to get the value from sheet "2". I know this works for a vlookup but clearly I'm out of my league!!

You guys are legends

 

[StephenCrump]

It's not clear from your post, but if Stage!B9 can only appear either in '1' or '2', then you can use:

=SUMIFS('1'!H:H,'1'!D:D,Stage!B9)+SUMIFS('2'!H:H,'2'!D:D,Stage!B9)

 

[Rogerisit]

Thank you so much!! It works

 

[Jonmo1]

Just FYI, the issue with your original formula is that 0 is NOT an error.
So if the first sumif on '1' returns 0, it still returns 0, because 0 is NOT an error, therefore not trapped by iferror.