Posts by jjarvis904

  • subtotal IF

    Thanks for the input,
    I tried the sumproduct and it doesn't seem to speed up the calculations compared to the arrays. Hopefully something will come up to where we can use the subtotal statement in this fasion.

  • subtotal IF

    Is there such a thing as subtotal if???
    I am using arrays all over my worksheet and it is really slowing the calculations down. I need to subtotal a column of numbers after filtering off on a criteria from one column but only summing those numbers based on another criteria from another column. It would be great if i could use subtotal IF or maybe subtotal(sumif(#,#)). Does this sound possible??