formula problem

L

legepe

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
 
L

legepe

=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

legep
 
P

Peo Sjoblom

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
 
L

legepe

=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 valu
in the cell is a particular colour

Can this be done?

Thanks

legep
 
Top