Re: 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" <legepe.2c3flv_1154825710.2089@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:legepe.2c3flv_1154825710.2089@xxxxxxxxxxxxxxxxxxxxxxxx

=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?action=getinfo&userid=15485
View this thread: http://www.excelforum.com/showthread.php?threadid=568697



.

Relevant Pages

  • Re: parsing a CSV line
    ... > The German version of Excel uses a semicolon instead of comma. ... Ouch! ...
    (comp.lang.lisp)
  • Re: parsing a CSV line
    ... The German version of Excel uses a semicolon instead of comma. ...
    (comp.lang.lisp)
  • in excel formula the comma (,) is no longer accepted but the semi.
    ... when entering formula in Excel the comma is no longer accepted but the ... semicolon now has to be used. ...
    (microsoft.public.excel.misc)
  • Re: formula problem
    ... Peo Sjoblom ... Excel 95 - Excel 2007 ... Northwest Excel Solutions ...
    (microsoft.public.excel.misc)
  • Refresh excel page
    ... Is there a way to refresh an excel page using a macro? ... legepe's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15485 ...
    (microsoft.public.excel.misc)
Loading