Formula/function in Apple Numbers that show dates in the last 7 days but not filtered dates that have no value.

Is there a formula or function that includes only calculating the cells in the last 7 days (see attached screenshot)? Please note that In columns G and J, cells that contain blanks or 0s are filtered out, hence the question.

The 6 here includes items that are filtered out. I would love to build a separate formula/function that would ONLY count the 4 dates in green above that are in the last 7 days AND have a value that is NOT 0 or blank in columns G and J.

Basically, filtering out these two dates below that have no value in columns. G and J (see attached screenshot below)

I hope this info helps!

Thank you,