Adding up for each occurence in excel -


i trying add quantity of ingredient each occurance of ingredient. example, if have these:

eggs    4 bread   1 tomato  1 eggs    3 grapefruit 2 milk    1 eggs    2 banana  1 

in 2 columns in excel, formula can use count how many eggs have? have output this:

eggs    9 bread   1 tomato  1 ... 

obviously list extremely long otherwise i'd add myself. vlookup returns quantity of first occurence of "eggs" , rest ignored.

you appreciated.

probably easiest/fastest way create simple pivot table using ingredient rows , qty values (sum), please see screenshot pivot table

if not familiar pivot table, here detailed tutorial beginners how use pivot tables in excel


Comments

Popular posts from this blog

How to get the arclen between two curve points in Maya? -

C++ Linked List -

git svn - Unignore directories in git-svn (adding directories to a sparse checkout) -