G
Guest
I want to use the function sumif. but I have two condition.
sumif(sheet1!a2:a100, sheet2!B2, Sheet1!D2100)
based on this, I want to add that when Sheet1!a2:a100 = Sheet2!B2, the value
on that row of column C must be larger than zero.
How can I do?
Thanks at advanced!
sumif(sheet1!a2:a100, sheet2!B2, Sheet1!D2100)
based on this, I want to add that when Sheet1!a2:a100 = Sheet2!B2, the value
on that row of column C must be larger than zero.
How can I do?
Thanks at advanced!