=COUNTIF(A5:A51,"=D240:Q251") Why will the cell D220 not TOTAL

[Terry]

I am having problems matching a range of number in the above cell range

 

[Mike H]

Terry,

Write down what you are trying to do and I'm sure someone can help.

Mike

 

[JLGWhiz]

Try:
=COUNTIF(A5:A51, "="&D240:Q251)

 

[JLGWhiz]

I am not so sure about your criteria. It might draw an error.