array formula
 

I have the following array formula:

SUM(($D$14:$D$1403=$B$1)*(F14:F1403<200000)*
($C$14:$C$1403=$B$6)))+(SUM(($D$14:$D$1403=$B$1)*
(F14:F1403199999)*($C$14:$C$1403=$B$6))


I don't want it to count blanks, cells with "x" or, cells
with 0. However, the <200000 counts 0s and blanks, and
the 199999 counts "x"s?

array formula
 

Your () don't balance, so i tis hard to see what you actuall formula does,
but every cell should either be <200000 or 199999

--
Regards,
Tom Ogilvy

"scrabtree" wrote in message
...
I have the following array formula:

SUM(($D$14:$D$1403=$B$1)*(F14:F1403<200000)*
($C$14:$C$1403=$B$6)))+(SUM(($D$14:$D$1403=$B$1)*
(F14:F1403199999)*($C$14:$C$1403=$B$6))


I don't want it to count blanks, cells with "x" or, cells
with 0. However, the <200000 counts 0s and blanks, and
the 199999 counts "x"s?

array formula
 

=SUM(($D$14:$D$1403=$B$1)*($F$14:$F$1403<200000)*( $F$14:$F$1403100000)*($C$
14:$C$1403=$B$6))

Entered with Ctrl+shift+enter

will give the count of cells between 100000 and 200000 (non inclusive) in
column F and column D equals value in B1 and Column C equal to value in B6.

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
Your () don't balance, so i tis hard to see what you actuall formula does,
but every cell should either be <200000 or 199999

--
Regards,
Tom Ogilvy

"scrabtree" wrote in message
...
I have the following array formula:

SUM(($D$14:$D$1403=$B$1)*(F14:F1403<200000)*
($C$14:$C$1403=$B$6)))+(SUM(($D$14:$D$1403=$B$1)*
(F14:F1403199999)*($C$14:$C$1403=$B$6))


I don't want it to count blanks, cells with "x" or, cells
with 0. However, the <200000 counts 0s and blanks, and
the 199999 counts "x"s?