Sumproduct

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

The first formula didn't work. I got a REF# error.

The second one totals everything in I and J, but if we
have data in the I and J column in the same row, we want
it to equal 1, not 2.

Any other suggestions? Thanks, Kim
 
Consider ('Fire Summary Sheet'!I4:I36+J4:J36<=0.25).
Are you trying to add the values in columns I and J of 'Fire Summary Sheet'
and compare the result with 0.25? If so, this formula will not do that. It
adds column I of 'Fire Summary Sheet' to column J of the sheet containing
the formula. You would need to use ('Fire Summary Sheet'!I4:I36+'Fire
Summary Sheet'!J4:J36<=0.25). Likewise in the part comparing with 0.
 
Back
Top