View Single Post
  #4   Report Post  
spottkitty
 
Posts: n/a
Default



=SUMIF('Working Copy'!A:A,"="&WC_WPH!A56, 'Working Copy'!K:K)

This formula gave me part of what I'm looking for...it did add up the
numbers! but there are numbers in column K with zeros in column J that I
don't want to add. The 1/0 in J turn on and off as the step is used in a
process.

Ideas? Thanks!!!!