SUMIF division
=IF(A1=Sheet1!A1,IF(Sheet1!K10,Sheet1!K1/Sheet1!L1,0))
"bob" wrote:
From Sheet 2, I'd like a formula to calculate the following using an array:
If Sheet1 Column A = Sheet2 Column A
AND
If Sheet1 Column K 0
THEN
Divide Sheet1 Column K by Sheet1 Column L
Can anyone help? Thanks.
Bob
|