Is there a macro which will sum cells Closed

Question

Hi all

I wonder if you could help.  I have a long grocery list which although I can sort alphabetically I am finding it difficult to sum similar grouped ingredients together.  Is there a macro that could look up each ingredient in the list, find if the ingredient exists further down the list and add the quantites together?  I don't know how to replace the ingredient name in the formula without manually overwritting it say from bacon to cheese, so it still takes ages to add all quantities of the same ingredient together.

Any help would be great.
Thanks
Nina
Configuration: Windows XP / Safari 532.5

rizvisa1 · Answer

How one can say that cheese and milk belong to same group or different ? 

Any ways lets say if you have a sheet like this 

Grocery Type -----Grocery-------------Cost 
dairy-----------------milk-----------------10 
dairy----------------- cheese------------20 
meat-----------------chicken-----------12 
dairy----------------- egg-----------------2 
meat-----------------beef---------------20 


Now to find cost of dairy products you can have this formula 

=SUMIF(A:A,"=dairy ",C:C)

Is there a macro which will sum cells

1 response

Similar discussions

Subscribe To Our Newsletter!