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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - =COUNTIF(A5:A51,"=D240:Q251") Why will the cell D220 not TOTAL (https://www.excelbanter.com/excel-programming/401621-%3Dcountif-a5-a51-%3Dd240-q251-why-will-cell-d220-not-total.html)

terry

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

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

Mike H

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

Terry,

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

Mike

"Terry" wrote:

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

JLGWhiz

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

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

"Terry" wrote:

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

JLGWhiz

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

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

"Terry" wrote:

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

All times are GMT +1. The time now is 09:50 PM.