excel - How can I divide a number of cells by another? -
i'm trying query divides number of cells number of cells, keep on getting error.
here contents of cells: http://i.gyazo.com/5954cf9dfcdc8cc430b81125d7313d22.png
=sum((z2:z19) / (v2:v19))
i #value! error. how come can't divide 1 selection other
try this:
=(sum(z2:z19)/sum(v2:v19))
Comments
Post a Comment