Calculating two separate cells properly

[Newbienew]

=SUM(COUNTIFS($B$3:$B$53,E57&"*",$U$3:$U$53,{"AFF","ENL"}&"*"))

So first let me say thank you to whom ever is willing to help out it is greatly appreciated. Above is my formula for counting one cell if another cell meets the either requirement. The problem that I am having is, is that, the formula works but if cell E57 is blank, the cell the formula is in still gives me a total number instead of just being 0.

If E57 is blank I would like for the cell the formula is in to be 0.

The only way that is works is if I type in place of E57, the actual words or name I want. "Jason" Issue here is I am trying to make up for typos with a space after the name. So both still are counted (Jason) and (Jason )

Problem with this is this formula is in 6 cells in the column. So that means every time someone new needs to be added, I or someone else has to unlock the spreadsheet and manually change the formula instead of just using the unlocked cell that is permitted. Is there any thing i can do so it doesn't still calculate all the AFF and ENL even if the entry cell is blank.

 

[jtakw]

Hi,

Just add an IF test:

=IF(E57="",0,SUM(COUNTIFS($B$3:$B$53,E57&"*",$U$3:$U$53,{"AFF","ENL"}&"*")))

 

[Newbienew]

WOW, Thank you so much, that has got to be the fastest response I think i have ever got so far. Thank you so much.

 

[jtakw]

You're welcome.