Let’s say a formula: =Sum(B1:B50)/Sum(A1:A50).
If there are any negatives or zero in B1:B50 or A1:A50, that record does not include in the calculation. For example, if A10 is -10 or 0, then A10 and B10 will be counted out even B10 is a positive number. Similarly, if B10 is -10 or 0, then A10 and B10 will be counted out even A10 is a positive number.
Thanks lot.
Dennis
If there are any negatives or zero in B1:B50 or A1:A50, that record does not include in the calculation. For example, if A10 is -10 or 0, then A10 and B10 will be counted out even B10 is a positive number. Similarly, if B10 is -10 or 0, then A10 and B10 will be counted out even A10 is a positive number.
Thanks lot.
Dennis