Forum Discussion
eliaskjohn
Feb 07, 2022Copper Contributor
summing of vlookup values
Can I have a better option for
- Feb 09, 2022
eliaskjohn
Feb 09, 2022Copper Contributor
Thank you. But it doesn't seems to be what my requirement is. I have just updated my query. can you please check it again?
OliverScheurich
Feb 09, 2022Gold Contributor
- eliaskjohnFeb 10, 2022Copper Contributor
OliverScheurich Thank you so much.
one more query. while copying the formula to another cells, following error is displayed. we can't even save the file without deleting the copied formula.- OliverScheurichFeb 12, 2022Gold Contributor
That's difficult to say without seeing the file or the formula in column H. Can you communicate the formula you entered in cell H8? Probably too many calculations are required to return the result of the formula.
- eliaskjohnFeb 16, 2022Copper Contributor
Thank you dear. OliverScheurich. I have sorted it. That error was because the formula was referring to the entire column. I have one more doubt. In the same way can we count the values instead of summing. Please see the attached image.