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!!

 

[Fluff]

What is your current formula?

 

[NateSC]

=IF(A1="","",  INSERT YOUR SUMIF EQUATION IF HERE  )

Where A1 is the cell you are checking for blanks.

 

[Huizar]

What is your current formula?

=SUMIFS('Budget 2023'!$J:$J,'Budget 2023'!$I:$I,I3) --->for the budget....so if March data for actuals numbers has no data in the cell, then i want the SUMIFs to just show zero for budget. Other wise if March data for actuals has a number then run the sumifs to generate the number.

Thanks!

 

[Huizar]

=IF(A1="","",  INSERT YOUR SUMIF EQUATION IF HERE  )

Where A1 is the cell you are checking for blanks.

=IF(A1="","",SUMIFS('Budget 2023'!$J:$J,'Budget 2023'!$I:$I,I3))....I tried this but it still generated the number for me in the following month with the budget number. Although March actual has no data, it still generated a number. I need it to show either 0 or blank.

Hopefully this is not confusing.

Thanks!

 

[Joe4]

=IF(A1="","",SUMIFS('Budget 2023'!$J:$J,'Budget 2023'!$I:$I,I3))....I tried this but it still generated the number for me in the following month with the budget number. Although March actual has no data, it still generated a number. I need it to show either 0 or blank.

Hopefully this is not confusing.

Thanks!

You would need to change the "A1" cell reference to whatever cell address this cell in your original example is:

 

[Huizar]

You would need to change the "A1" cell reference to whatever cell address this cell in your original example is:
View attachment 89543

I did but it still generated a number.

IF(D2="","",SUMIFS('Budget 2023'!$J:$J,'Budget 2023'!$I:$I,I3))...D2 would represent the circle in red above.

 

[Joe4]

That tells me then that cell D2 is really not empty.
What is in there? A space? A formula that returns a blank?
If a formula, please post the exact formula in cell D2.

 

[Huizar]

That tells me then that cell D2 is really not empty.
What is in there? A space? A formula that returns a blank?
If a formula, please post the exact formula in cell D2.

=SUMIFS('Actual Report'!$I:$I,'Actual Report'!$L:$L,I3)--->Its reading the actuals for the month. below is what my sheet looks like. Since Actuals for March have not generated it is basically 0.

 

[NateSC]

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))