Hi there,

Its my first post, plz take it easy

I've inherited a spread sheet and am struggling to make a change to the formula.



=SUMIFS(INDIRECT("'"&COLUMNS($B$1:B1)&"'!$I$11:$I$ 900"),INDIRECT("'"&COLUMNS($B$1:B1)&"'!$C$11:$C$90 0"),$E3,INDIRECT("'"&COLUMNS($B$1:B1)&"'!$F$11:$F$ 900"),$D3, INDIRECT("'"&COLUMNS($B$1:B1)&"'!$G$11:$G$900"),$B 3)

Basically, at the moment in the above all three criteria's are AND. However, I want (D3 OR E3) AND B3, I hope that makes sense.

Without a context, it's difficult to know what needs changing. Please attach a worksheet containing the data used by the formula and a description of the desired outcome. You can do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Just do =SUMIFS() + SUMIFS()

take out the D3 section on the first one and take out the E3 on the second one.

That will give D3 PLUS E3. The OP wants D3 OR E3...

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]