Creating a calculated field, count of non-zero items in filtered results

Having some trouble with a calculated field. In the attached workbook the problem column is E.

If you doubleclick on D7 it will open a sheet showing the 6 filtered rows that make up the current results.

Column F is properly counting the number of sheets that variable was found on, though I'm not sure I trust the calc. If a sheet were listed multiple times (column A of the database) for a specific variable, I'd prefer this field still only count each unique sheet once.... but I digress.

COLUMN E needs to display a count of the values that are in the AVERAGE (D2). In this sample filtering I'd want the result to be 2, as there are 2 non-zero answers in the current calculation.

Can you help me adjust the column E calculated field to do this? I'm stumped atm.

I was overthinking it. Simple "Count of Values" was all I needed. (embarrassed)