Hi

No need for any formulae to achieve this.
Place your cursor in the cell where you want your results to begin.
DataConsolidateselect range of your data A2:B10tick Use labels in Left
ColumnOK

--
Regards
Roger Govier



"Javier Diaz" wrote in message
...
So guys, heres another one

Say in CElls A2:A10 I have values like so;

food
food
test
trial
trial
test

And in B2:B10 I have qtys. I want a total with no filter or pivot that
would return the unique entries into A12 like so

Food
Rest
Trial
Test

Thats about it, I'll take care of the sumif formula for the qy based on
this
one thing that I reallly need. Pleaseeeeeeeeeeeee.