If Cell is Blank then do no generate a Sumif for the Month

[Huizar]

Hello All,

This is probably an easy ask, but i'm struggle to find my solution. I'm trying to generate a blank cell if another cell has zero data else i want to run the sumifs formula. Hopefully this is easy to understand. Below is the example:

	Jan	Feb	Mar
Actuals	has sumif formula	has sumif formula	no data yet
Budget	sumif formula for budget	sumif formula for budget	If no data in cell above, then make 0, but if there is data above, then run sumif formula for budget

Anyone's help is greatly appreciated.

Thanks!!

 

[Huizar]

Jut change what the IF statement is checking. Instead of checking for a blank, because you have accounting formatting you should be checking for a 0.

IF(D2=0,"",SUMIFS('Budget 2023'!$J:$J,'Budget 2023'!$I:$I,I3))

Oh man so basic, yet took me a couple hours for such a simple code. Much appreciated. I appreciate your help and everyone else that has chimed in on this thread!

Thanks!!!!!!!!!!!