Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with COUNTIF being off by 1 | Excel Worksheet Functions | |||
COUNTIF by date range problem | Excel Worksheet Functions | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Countif Problem | Excel Discussion (Misc queries) | |||
COUNTIF Problem | Excel Discussion (Misc queries) |