Countif with a range an criteria declared in a let statement,

Hi, is it possible to get countif to work with ranges declaed in a let statement,

Please Login or Register  to view this content.

K3 = spill from filter,

But what I have tried to do is put this into a let statement and then use it

Please Login or Register  to view this content.

but this results in an error? I have managed to use match,

So my question is, is there a way to get countif to work with the ranges and filter spill named in a let statement?
If it can't be done at least I can stop trying.

Richard

What are your expected results?

I think you need this:

Please Login or Register  to view this content.

COUNTIF(S) won't work with arrays (only ranges).

Glad to have helped.

Thanks for the rep.