Count cells when data is retrieved by a formula

Hi everyone,

I have an excel sheet where most of the filling in is done by formulas.
For example I have one general entry list and all other will retrieve their info from this list.

Downside for me if I want to do a count of filled in cells it does show me also the counts for the blank cells because they all contain a formula.
Is there a way around this while keeping the formulas?

The same issue occurs when sorting a column with formula filled values.

My question is if it's possible to do a count or sort based not on the actual values but on the displayed cell values?

Thanks for helping me out.

You'd be better attaching a Sample workbook (see the big yellow banner for instructions) on this as it sounds as though it's something with multiple solutions and a better understanding of what you're looking at would be hugely beneficial

Yes was still working on the file to have it as complete as possible.

In the attachment the exaple file.
The first orange tab shows in red what I would like it to do.

Thanks for the tips I will try them out.

I need to sort them based on a result at the "Gewicht" column so all columns are sorted based on those values.
Only because of the cells containing a formula they won't sort on the displayed value but on the formula which does not work as I expect it to.

Brilliant the count is working just fine. I think I overlooked this counting with the ""value.

Thanks a million