I'd like to create a formula that creates multiple arrays based on an if statement, multiplies the arrays, and then sums the products.
I'd like to sum their product if A doesn't equal 0. My current formula works, but I'd like to be able to do this with only one if statement.
=SUMPRODUCT(IF(A1:A5<>"",A1:A5%),IF(A1:A5<>"",B1:B5))

Aucun commentaire:
Enregistrer un commentaire