Re: Sum Values For One Column According To The Values In Another Column?
I just wanted to quickly add that the problem I have with the SUMIF function is that I have way too many values in columnA and that makes it difficult for me to individually specify the criteria. Is there anyway Excel can automatically sum up the values in column B for all recurrring instances in column A? I noticed i some previous responses that a Pivot table can be used. I have never heard of it or used it before. So please help!!