Count the occurence of multiple (4 conditions). - Need urgent help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "CT" <CT@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 1 May 2005 17:34:03 -0700

Hi,

I am unable to get the correct count using the formula :

=SUM(IF(A1:A999="
A",IF(D1:D999="D>d",IF(F1:F999="1",IF(E1:E999="1",1,0)))))

I am trying to get no of records with
" A" values in Column A,
"D>d" values in Column D,
"1" values in Column F,
"1" values in Column E

and Sum all the counts- after applying the nested filters.

Can someone help me in debugging the same?
Will appreciate early response!

Thanks in advance,

.

Follow-Ups:
- Re: Count the occurence of multiple (4 conditions). - Need urgent help
  - From: Jerry W. Lewis
- Re: Count the occurence of multiple (4 conditions). - Need urgent help
  - From: Ragdyer

Prev by Date: columns misaligned after save
Next by Date: Re: How do I set up an index page that opens other wkshts?
Previous by thread: columns misaligned after save
Next by thread: Re: Count the occurence of multiple (4 conditions). - Need urgent help
Index(es):
- Date
- Thread

Relevant Pages

Re: Count the occurence of multiple (4 conditions). - Need urgent help
... A simpler approach would use the fact that you can coerce TRUE into 1 and FALSE into 0, so that the following formula should work and does not ... and Sum all the counts- after applying the nested filters. ... Can someone help me in debugging the same? ... Will appreciate early response! ...
(microsoft.public.excel.misc)
Re: analysis of java application logs
... Ugly, I know, but quite efficient, since when debugging is off ... cost of the method call cost is. ... static final boolean debug = false; ... It wasn't until much later that I was told that the response had to be ...
(comp.lang.java.programmer)
RE: XP SP2
... Thank you for your response. ... The problem does only appear when debugging ASP.NET programs. ... whether it only occurs when the popup-blocker is activated. ... the problem again I will immediately test whether disabling the popup-blocker ...
(microsoft.public.vsnet.debugging)
Re: Multi-Level BOM (Bill of Materials)
... > Thanks for your response MG =) I have tried this example as well, ... I will try show you how I see it in my head (I hope the ... > formatting stays): ... Prev by Date: ...
(microsoft.public.access.queries)
Re: Multi-Level BOM (Bill of Materials)
... > Thanks for your response MG =) I have tried this example as well, ... I will try show you how I see it in my head (I hope the ... > formatting stays): ... Prev by Date: ...
(microsoft.public.access.queries)