yurble_vn
08-25-2009, 07:59 PM
Hi All,
I have used subtotal to sum a range as below:
Cell1: If(criteria, subtotal(Cell2:Cell6), sum(range)) --> subtotal
Cell2: If(criteria, subtotal(Cell3:Cell6), sum(range)) --> sum
Cell3: If(criteria, subtotal(Cell4:Cell6), sum(range)) --> sum
Cell4: If(criteria, subtotal(Cell5:Cell6), sum(range)) --> sum
Cell5: If(criteria, subtotal(Cell6:Cell6), sum(range)) --> sum
Cell6: subtotal(cell1:cell5)
my purpose is make the function consitent. But the subtotal in cell1 ignore to sum the value in cell2. I suppose it considered these cells are using subtotal function, so it dont count that into its sum.
Is there anyway to solve this?
thanks and best regards,
I have used subtotal to sum a range as below:
Cell1: If(criteria, subtotal(Cell2:Cell6), sum(range)) --> subtotal
Cell2: If(criteria, subtotal(Cell3:Cell6), sum(range)) --> sum
Cell3: If(criteria, subtotal(Cell4:Cell6), sum(range)) --> sum
Cell4: If(criteria, subtotal(Cell5:Cell6), sum(range)) --> sum
Cell5: If(criteria, subtotal(Cell6:Cell6), sum(range)) --> sum
Cell6: subtotal(cell1:cell5)
my purpose is make the function consitent. But the subtotal in cell1 ignore to sum the value in cell2. I suppose it considered these cells are using subtotal function, so it dont count that into its sum.
Is there anyway to solve this?
thanks and best regards,