Help changing a formula

[whoamimjg]

Currently, I have a formula that says if you place a number in cell E34 and it is greater than 3 then it will take a total amount and divide it between everyone in the cell range E33 to E44. I want to eliminate the must be greater than 3 option and just distribute the total between the cell range evenly.

This sheet calculates a bartender's total tip payout between how many bartenders worked that shift. So they get 3% of total bar sales. If 7 wait staff sell $1000 then 3% of that $1000 gets split between the bartenders evenly. We are no longer requiring them to work more than 3 hours to get the tip out, that's why I am changing the formula.
Attached is a picture of a cell sheet with formulas.

I hope someone can help, Thank you!

 

[johnny51981]

Give this a go

=IF(E34<>””,0.03/COUNTIF($E$33:$E$42,”<>”&””),0)

 

[Joe4]

Give this a go

=IF(E34<>””,0.03/COUNTIF($E$33:$E$42,”<>”&””),0)

You need to be sure to use straight double-quotes, like " in your Excel formulas.
Excel does NOT like slanted ones like ”.

 

[johnny51981]

That was a copy and past from Word. My bad.

 

[whoamimjg]

That produces a error #NAME?

 

[Joe4]

That produces a error #NAME?

Try changing the double-quotes, like I mentioned, so it looks like this:

=IF(E34<>"",0.03/COUNTIF($E$33:$E$42,"<>"&""),0)

Note, I have not evaluated the logic of the formula johnny posted.
I only am commenting on the structure issues.

 

[whoamimjg]

That works by just putting a 0 in the cell. I appreciate your help!