I saw a thread Using VLOOKUP to sum values cells vertically that was having the same problem, but didn't really get an answer.
I am using VLOOKUP to pull categories from reports I'm getting from a management software =VLOOKUP(A3,$B$3:$C$846,1,0). This will give a category such we can call NG. In another column I've tried using =SUMIF(C:C,VLOOKUP(D3,$B$3:$C$846,2,0)) to sum all values with duplicate categories. This will work if the value of a category is the same, but if the corresponding value is different it will only pull the first value of the VLOOKUP.
What I'd like to do is sort the categories using the VLOOKUP (it gives me the correct spacing to transplant those values into other excel calculations) and sum the corresonding values associated with the duplicate categories. Is this possible or another way to go about it?
I am using VLOOKUP to pull categories from reports I'm getting from a management software =VLOOKUP(A3,$B$3:$C$846,1,0). This will give a category such we can call NG. In another column I've tried using =SUMIF(C:C,VLOOKUP(D3,$B$3:$C$846,2,0)) to sum all values with duplicate categories. This will work if the value of a category is the same, but if the corresponding value is different it will only pull the first value of the VLOOKUP.
What I'd like to do is sort the categories using the VLOOKUP (it gives me the correct spacing to transplant those values into other excel calculations) and sum the corresonding values associated with the duplicate categories. Is this possible or another way to go about it?