robocop1906
Board Regular
- Joined
- Jan 15, 2003
- Messages
- 143
I get a #Value error form the formula below. Is it correct? Im trying to compare A:A with K:K and if they match sum sheet1 AA:AA only if the values are greater than 0
=SUMIF(A:A,Sheet1!K:K,IF(Sheet1!AA:AA,">0"))
=SUMIF(A:A,Sheet1!K:K,IF(Sheet1!AA:AA,">0"))