Subtotal & Min Circuit Breaker

  • I have attached a sample, I have a sales model that includes costs of goods sold. several of the suppliers offer rebates as a credit against cost of goods, but for projection purposes, I need a "circuit breaker" for minimum cost of goods when the credit is too high. using Subtotal "9" embedded in a min, I can generate the correct cost of goods, but the subsequent subtotal ignores the circuit breaker.


    Any ideas of how to get the totals to add up would be appreciatedforum.ozgrid.com/index.php?attachment/71025/forum.ozgrid.com/index.php?attachment/71025/? See attached.

  • Re: Subtotal & Min Circuit Breaker


    Try using a simple =SUM(G3:G8) in cell G9.


    I am not sure why the subtotal formula didn't work though.

  • Re: Subtotal & Min Circuit Breaker


    Quote from Kieran;783480

    Try using a simple =SUM(G3:G8) in cell G9.


    I am not sure why the subtotal formula didn't work though.


    A simple sum works, but subsequent subtotals don't and the whole spreadsheet gets screwed up. I don't know why it doesn't work either, but it seems to be skipping the cell, and instead summing the previous cells

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!