Excel subtotals cells with a formula - HELP

J

jay

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.
 
B

Bob Phillips

You could try

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


--

HTH

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

Rookie_User

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?
 
R

Rookie_User

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.
 
P

Peo Sjoblom

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