COUNTIF and IF statements to count non-blank cells only

Hi I would like the following formulas below to only count the cells that have a value. If there is no value, to return a blank cell:

=E14*F14
=IF(G14>12,"H",(IF(G14>4,"M","L")))
=COUNTIF(E14:AZ88, "L")

Any help is greatly appreciated.

Thank you.

Originally Posted by FDibbins

You only have 1 formula that is counting anything there, so perhaps...
=if(COUNTIF(E14:AZ88, "L")<1,"",COUNTIF(E14:AZ88, "L")

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

I have attached a sample.

Originally Posted by FDibbins

Thanks. Where do you want these, and what is your expected outcome?

Thank you, in cell H14. I can copy the formula to the rest of the cells.

I used your formula above for the other cells.

Originally Posted by FDibbins

Will this work for you?
=IF(G14=0,"",IF(G14>12,"H",IF(G14>4,"M","L")))

That is perfect! THANK YOU!