View Single Post
  #1   Report Post  
jay
 
Posts: n/a
Default 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.