ExcelBanter - countif problem when using range name

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

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

- - countif problem when using range name (https://www.excelbanter.com/excel-programming/367567-countif-problem-when-using-range-name.html)

Kieranz[_2_]

countif problem when using range name

Hello All
I have a number say 6 in cell A3 which is named as 'MP01'; in another
cell i have a formula =countif(D1:D10,"MP01") but this does not work!
However if i have =countif(D1:D10,MP01+2) then this works.
Many thks for your help
Rgds
KZ

colofnature[_89_]

countif problem when using range name

Change the formula to

=countif(D1:D10,""&MP01)

Co

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=56252

Andrew Taylor

countif problem when using range name

=COUNTIF(D1:D10,""&MP01)

Kieranz wrote:
Hello All
I have a number say 6 in cell A3 which is named as 'MP01'; in another
cell i have a formula =countif(D1:D10,"MP01") but this does not work!
However if i have =countif(D1:D10,MP01+2) then this works.
Many thks for your help
Rgds
KZ

Kieranz[_2_]

countif problem when using range name

Andrew
Many thks
KZ

Andrew Taylor wrote:
=COUNTIF(D1:D10,""&MP01)

Kieranz wrote:
Hello All
I have a number say 6 in cell A3 which is named as 'MP01'; in another
cell i have a formula =countif(D1:D10,"MP01") but this does not work!
However if i have =countif(D1:D10,MP01+2) then this works.
Many thks for your help
Rgds
KZ

All times are GMT +1. The time now is 11:39 PM.