Easy Question? IFTHEN

[rthompson55125]

Hello, I have the following formula below that sums finances by month. If the SUMRANGE (E:E) = zero, I'd like it to refer to cell E10 (alternative data). Could someone help me insert an IF E:E is zero, then E10? If the there is a number in E:E play out the formula.

THANK YOU!



=SUMIFS('Material Actuals'!E:E,'Material Actuals'!$B:$B,IF('Manager''s Dashboard'!$L$2="All","<>",'Manager''s Dashboard'!$L$2),'Material Actuals'!$C:$C,'Manager''s Dashboard'!$L$4)

 

[theBardd]

Try

=IF(SUM('Material Actuals'!E:E)=0,'Material Actuals'!E10,SUMIFS('Material Actuals'!E:E,'Material Actuals'!$B:$B,IF('Manager''s Dashboard'!$L$2="All","<>",'Manager''s Dashboard'!$L$2),'Material Actuals'!$C:$C,'Manager''s Dashboard'!$L$4))

 

[rthompson55125]

Try

=IF(SUM('Material Actuals'!E:E)=0,'Material Actuals'!E10,SUMIFS('Material Actuals'!E:E,'Material Actuals'!$B:$B,IF('Manager''s Dashboard'!$L$2="All","<>",'Manager''s Dashboard'!$L$2),'Material Actuals'!$C:$C,'Manager''s Dashboard'!$L$4))

Perfect! Thank you for taking the time to help!