View Full Version : Solved: Add within range?
legepe
08-05-2006, 12:43 PM
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
08-05-2006, 01:57 PM
Try
=SUMAPRODUCTO(CONTAR.SI(B14:C14;{1,2,3,4}))
legepe
08-05-2006, 02:19 PM
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
08-05-2006, 02:32 PM
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
08-05-2006, 02:40 PM
=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
08-05-2006, 02:45 PM
NO, what I mean is
=SUMAPRODUCTO(CONTAR.SI(B14:AC14,{1,2,3,4}))
legepe
08-05-2006, 04:47 PM
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
08-06-2006, 01:19 AM
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
08-06-2006, 10:59 AM
=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
08-06-2006, 11:43 AM
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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.