Try

=SUMA(CONTAR.SI(B14:AC14,{1,2,3,4}))



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com




"legepe" wrote in
message ...

Hi,
Can anyone tell me what is wrong with the formula below
I need it to add if in the range it is 1,2,3, or 4

=CONTAR.SI(B14:AC14,"1,2,3,4")

Thanks
legepe


--
legepe
------------------------------------------------------------------------
legepe's Profile:
http://www.excelforum.com/member.php...o&userid=15485
View this thread: http://www.excelforum.com/showthread...hreadid=568697