Embedded Count If

[neorobert]

I'm having a problem either with the syntax of the formula or the th
whole formula itself...

=COUNT(IF((GBPUSD!A:A<=C1)*(GBPUSD!A:A>=A1), (GBPUSD!D),"<0"))

-The formula is in one sheet, and the array is on another.
-Cells A1 and C1 are the specified date ranges I need to filter by.
-Range A:A contains date values
-Range D contains percentage values
(Yes, I'm also entering the array with C+S+E...)

Worksheet GBPUSD contains several years worth of information and I'
attempting to filter out positive, negative and zero values based on th
specified date range on the formula worksheet.

I'm currently encountering the problem that the formula merely count
the total values in Column D regardless of the formula containing <0 >
or =0 ...

If anyone can shed some light on this problem it would be greatl
appreciated

 

[Claus Busch]

Hi,

Am Thu, 10 May 2012 15:21:27 +0000 schrieb neorobert:

I'm having a problem either with the syntax of the formula or the the
whole formula itself...

=COUNT(IF((GBPUSD!A:A<=C1)*(GBPUSD!A:A>=A1), (GBPUSD!D),"<0"))

-The formula is in one sheet, and the array is on another.
-Cells A1 and C1 are the specified date ranges I need to filter by.
-Range A:A contains date values
-Range D contains percentage values
(Yes, I'm also entering the array with C+S+E...)

Try:
=SUMPRODUCT(--(GBPUSD!A1:A1000>=A1),--(GBPUSD!A1:A1000<=C1),--(GBPUSD!D11000<=0))


Regards
Claus Busch