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
if not familiar pivot table, here detailed tutorial beginners how use pivot tables in excel
Comments
Post a Comment