Excel subtotals cells with a formula - HELP
 

I am subtotaling (using count) a few columns. When the column truly has
nothing in the cell the subtotal does not count it. However, if the cell has
a formula "=countif(xxxxxxx)" then it counts it in the subtotal - Why? I am
so confused and under pressure.

Excel subtotals cells with a formula - HELP
 

You could try

=SUMPRODUCT(--(rng<""))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"jay" wrote in message
...
I am subtotaling (using count) a few columns. When the column truly has
nothing in the cell the subtotal does not count it. However, if the cell
has
a formula "=countif(xxxxxxx)" then it counts it in the subtotal - Why? I
am
so confused and under pressure.

Excel subtotals cells with a formula - HELP
 

Well I am not sure how/what that is - smile. I use the subtotal because we
use the "at each change in" field. Not sure how this one will work, but I
will try it. Do you know why its counting a cell that has a formula in it?

"Bob Phillips" wrote:

You could try

=SUMPRODUCT(--(rng<""))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"jay" wrote in message
...
I am subtotaling (using count) a few columns. When the column truly has
nothing in the cell the subtotal does not count it. However, if the cell
has
a formula "=countif(xxxxxxx)" then it counts it in the subtotal - Why? I
am
so confused and under pressure.

Excel subtotals cells with a formula - HELP
 

This is the current subtotal forumula:
=SUBTOTAL(3,AH4175:AH4601)

And within this defined range I have this formula in those cells,
=IF(COUNTIF(October!A:A,P4584)0,"X","")

And if one of those cells is truly empty it works, if this formula is in the
cell then it counts the cell and it shouldn't.


"Rookie_User" wrote:

Well I am not sure how/what that is - smile. I use the subtotal because we
use the "at each change in" field. Not sure how this one will work, but I
will try it. Do you know why its counting a cell that has a formula in it?

"Bob Phillips" wrote:

You could try

=SUMPRODUCT(--(rng<""))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"jay" wrote in message
...
I am subtotaling (using count) a few columns. When the column truly has
nothing in the cell the subtotal does not count it. However, if the cell
has
a formula "=countif(xxxxxxx)" then it counts it in the subtotal - Why? I
am
so confused and under pressure.

Excel subtotals cells with a formula - HELP
 

=SUMPRODUCT(--(AH4175:AH4601<""),(SUBTOTAL(3,OFFSET(AH4175,ROW( AH4175:AH460
1)-MIN(ROW(AH4175:AH4601)),,))))


--

Regards,

Peo Sjoblom

"Rookie_User" wrote in message
...
This is the current subtotal forumula:
=SUBTOTAL(3,AH4175:AH4601)

And within this defined range I have this formula in those cells,
=IF(COUNTIF(October!A:A,P4584)0,"X","")

And if one of those cells is truly empty it works, if this formula is in
the
cell then it counts the cell and it shouldn't.


"Rookie_User" wrote:

Well I am not sure how/what that is - smile. I use the subtotal because
we
use the "at each change in" field. Not sure how this one will work, but
I
will try it. Do you know why its counting a cell that has a formula in
it?

"Bob Phillips" wrote:

You could try

=SUMPRODUCT(--(rng<""))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"jay" wrote in message
...
I am subtotaling (using count) a few columns. When the column truly
has
nothing in the cell the subtotal does not count it. However, if the
cell
has
a formula "=countif(xxxxxxx)" then it counts it in the subtotal -
Why? I
am
so confused and under pressure.