=COUNTIF($Q$7:$Q$57,"="&Z6)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"neda5" wrote in message
...
I am using the countif formula and when I hard code the criteria it works
but
when I link the criteria to a cell it doesn't. Bellow is an example of
what
is happening. Can anyone help?
Thanks
work: =COUNTIF($Q$7:$Q$57,"=0.45")
doesn't work: =COUNTIF($Q$7:$Q$57,"=&Z6")
|