Extra condition to SUMIFS

[ddub25]

=IF(SUMIFS($E$32:$E$43,$A$32:$A$43,$A$91,$B$32:$B$43,"Investor")=0,$H$91*G107,SUMIFS($E$32:$E$43,$A$32:$A$43,$A$91,$B$32:$B$43,"Investor"))

I'd like to adapt this formula to always return 0 IF E107=0. Can anyone help?

Dan

 

[yogeshmaney]

=if(E107=0,0,IF(SUMIFS($E$32:$E$43,$A$32:$A$43,$A$91,$B$32:$B$43,"Investor")=0,$H$91*G107,SUMIFS($E$32:$E$43,$A$32:$A$43,$A$91,$B$32:$B$43,"Investor")))

 

[ddub25]

Thanks, yogeshmaney.

Dan

 

[yogeshmaney]

U r welcome chief...