Solved: Add within range?

[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

[Bob Phillips]

Try

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

[legepe]

Thanks for that, but I cannot make it work....
The formula =CONTAR.SI(B14:AC14,"1") works. But I need to to add when there is another number???

[Bob Phillips]

Thanks for that, but I cannot make it work....
The formula =CONTAR.SI(B14:AC14,"1") works. But I need to to add when there is another number???

That is what mine does. I used a ; separator, but I notice that yiu use , try that in my formula.

[legepe]

=SUMAPRODUCTO(CONTAR.SI(B14:AC14;{1;2;3;4}))
Firstly it shows an error where I?ve highlighted
And, have I put the seperators into the formula correctly?

[Bob Phillips]

NO, what I mean is

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

[legepe]

No I cannot get it to work it is now highlighting the number 1?
=SUMAPRODUCTO(CONTAR.SI(B14:AC14,{1,2,3,4}))
Can you help me some more?

[Bob Phillips]

No I cannot get it to work it is now highlighting the number 1?
=SUMAPRODUCTO(CONTAR.SI(B14:AC14,{1,2,3,4}))
Can you help me some more?

Post the workbook.

[legepe]

=SUMA(CONTAR.SI(B14:AC14,{1;2;3;4}))
Managed to do it with some playing around
Thanks for all your help
legepe

[Bob Phillips]

Then the non-array entered

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

should work just as well. Why did you change your settings?