Re: formula problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com>
Date: Sat, 5 Aug 2006 17:18:52 -0700

Try

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

--

Regards,

Peo Sjoblom

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

"legepe" <legepe.2c3d27_1154822409.683@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:legepe.2c3d27_1154822409.683@xxxxxxxxxxxxxxxxxxxxxxxx

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

Follow-Ups:
- Re: formula problem
  - From: legepe

References:
- formula problem
  - From: legepe

Prev by Date: Re: Excel files become "Read Only" after copying to CD; WHY?
Next by Date: Re: Excel files become "Read Only" after copying to CD; WHY?
Previous by thread: formula problem
Next by thread: Re: formula problem
Index(es):
- Date
- Thread

Relevant Pages

Re: Counting only Unique cells
... I forgot to mention that D2 holds the criteria in the first solution ... Excel 95 - Excel 2007 ... Northwest Excel Solutions ... "Peo Sjoblom" wrote: ...
(microsoft.public.excel.worksheet.functions)
Re: I need to know what kinda Function to Use in A Worksheet
... matching data. ... "Peo Sjoblom" wrote: ... Excel 95 - Excel 2007 ... Northwest Excel Solutions ...
(microsoft.public.excel.worksheet.functions)
Re: How do I find unknown interest rate using TVM functions
... "Peo Sjoblom" wrote: ... Excel 95 - Excel 2007 ... Northwest Excel Solutions ... I invest $10 today and in 12 years I need it to be worth $18 how do I come ...
(microsoft.public.excel.worksheet.functions)
Re: Compare alpha and numeric values within a range
... Jim Cone ... Excel 95 - Excel 2007 ... Northwest Excel Solutions ... "Peo Sjoblom" wrote: ...
(microsoft.public.excel.worksheet.functions)
Re: Compare alpha and numeric values within a range
... Excel 95 - Excel 2007 ... Northwest Excel Solutions ... "It is a good thing to follow the first law of holes; ... "Peo Sjoblom" wrote: ...
(microsoft.public.excel.worksheet.functions)