Transformation of IF formula to embed another formula

[virtuosok]

Hi,
I have to transform this formula

=IF(ISBLANK(A2),1,SUMIFS('Export Results ITD thru Mar2021'!$N$2:$N$99998, 'Export Results ITD thru Mar2021'!$K$2:$K$99998,"*" & $A$2 & "*",'Export Results ITD thru Mar2021'!$B$2:$B$99998,$F$1,'Export Results ITD thru Mar2021'!$D$2:$D$99998,Calc!E2))

by substituting "1" at the beginning of the formula (prior to SUMIFS) with

SUMIFS('Export Results ITD thru Mar2021'!$N$2:$N$99998, 'Export Results ITD thru Mar2021'!$L$2:$L$99998,$A$4,'Export Results ITD thru Mar2021'!$B$2:$B$99998,$F$1,'Export Results ITD thru Mar2021'!$D$2:$D$99998,Calc!E2

Tried entering as is, or enclosing this bit into brackets, doesn't work... must be missing something obvious.
The second component works on its own, but not when embedded the way I try it to embed...

 

[jtakw]

Hi,

May be you're just missing the closing bracket for your 2nd formula?

Try this, Untested:

=IF(ISBLANK(A2),SUMIFS('Export Results ITD thru Mar2021'!$N$2:$N$99998, 'Export Results ITD thru Mar2021'!$L$2:$L$99998,$A$4,'Export Results ITD thru Mar2021'!$B$2:$B$99998,$F$1,'Export Results ITD thru Mar2021'!$D$2:$D$99998,Calc!E2),SUMIFS('Export Results ITD thru Mar2021'!$N$2:$N$99998, 'Export Results ITD thru Mar2021'!$K$2:$K$99998,"*" & $A$2 & "*",'Export Results ITD thru Mar2021'!$B$2:$B$99998,$F$1,'Export Results ITD thru Mar2021'!$D$2:$D$99998,Calc!E2))

 

[virtuosok]

Doh. How could I possibly miss that... Thank you jtakw!

 

[jtakw]

You're welcome, glad to help.