Did you enter the formula with ctrl + shift & enter?
Also note that if you happen to have an error in any of the ranges you will
get that particular error
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
wrote in message
ups.com...
Hi,
I am new to excel formulas I am trying to count two criteria each is in
a different column I found this formula in Excel help but it keeps
giving me !Value instead of a number any help would be greatly
appreciated
The formula is =SUM(IF(B3:B65="CCO",IF(D3:D65="Access and
Permission",1,0)))