Thank you so much!! This worked great!
bj wrote:
try something like
=sumproduct(--(visit range<0),Cost range)
in your totals column.
note the Visit range and Cost range must be the same size
the --( converts the true false logical statement to a 1,0 numeric value.
Hello,
[quoted text clipped - 17 lines]
I hope this makes sense!! If anybody has any idea or resources that I could
follow up with, I'd greatly appreciate it!!
|