Hi,
I have to transform this formula
by substituting "1" at the beginning of the formula (prior to SUMIFS) with
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...
I have to transform this formula
Excel 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))
Excel Formula:
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
The second component works on its own, but not when embedded the way I try it to embed...