Bianca Naicker
New Member
Hi hope you are well. My name is Bianca, I am deaf.
I need help with counta or countif.
When i added drop down list in excel and the blanks under the items are showing so i want to remove blank. I used counta or countif to =INDIRECT(SUBSTITUTE(E3,"","")) but not working at all.
Please assist.
Thank you
I need help with counta or countif.
When i added drop down list in excel and the blanks under the items are showing so i want to remove blank. I used counta or countif to =INDIRECT(SUBSTITUTE(E3,"","")) but not working at all.
Please assist.
Thank you