This works fine. But I want count of rate which is column C based on date range and name of "A"
What do you mean by "count" of rate... an actual count
of items (which is what I gave you) or a sum
of the rates meeting the conditions. If the latter...