Excel functions Enter # in I56 and J56, pull # from array below (G60 thru Q160) with I56 the # on top and J56 the # on the side result will be intersecting row and column with result and function IN M56.
It seems very confusing what you are saying. What do you mean when pull # and giving an area G60 through Q160. Is it sum of all those cells or average?
It seems very confusing what you are saying. What do you mean when pull # and giving an area G60 through Q160. Is it sum of all those cells or average?
You can't post conmments that contain an email address.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
It seems very confusing what you are saying. What do you mean when pull # and giving an area G60 through Q160. Is it sum of all those cells or average?
×