Formula based off of number of records

[lemonap618]

Hello All,
I appreciate all the help you have provided me over the last few weeks - I'm almost done with my project!

I asked a similar question earlier, marked it solved, and now have a follow up. On the attached in cell K24, I need to spread its value ($26,967.00) evenly across G30:G44. As you can see, there are 2 products in this section (G31 and G32) so the values for both these fields should be -26,976/2 = -13,483.5. Now, if there were another value added to G33, then I need the formula to update to -26,976/3 and so on and so forth. If there are no values in G30:G44 then I would like the to see 0 in those cells.
I hope Im not being confusing..it is super late

Thanks!

[AliGW]

Wrap the formula in a blank test;

=IF(F30="","",$K$24/(COUNT($F$30:$F$44)))

You'll need to do this in the adjacent column, too:

=IF(F30="","",formula)

It's super early here ...

[lemonap618]

thank you!