formula problem
 

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

formula problem
 

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

formula problem
 

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

I´ve highlighted the 1 where it is showing an error

Can you help me some more

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

formula problem
 

Try semicolon instead of comma and see if it helps,


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


This works fine for me using US version of Excel

=SUM(COUNTIF(B14:AC14,{1,2,3,4}))

worked fine and returned the correct result when I tested it


--


Regards,

Peo Sjoblom

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



"legepe" wrote in
message ...

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

I´ve highlighted the 1 where it is showing an error

Can you help me some more

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

formula problem
 

Thanks for that it works fine


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

formula problem
 

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

How can I use this formula to detect a colour of a cell or if the value
in the cell is a particular colour

Can this be done?

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