Is there a macro which will sum cells
Closed
nina
-
Apr 12, 2010 at 05:26 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 12, 2010 at 05:39 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 12, 2010 at 05:39 PM
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
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
Related:
- Is there a macro which will sum cells
- Excel macro to create new sheet based on value in cells - Guide
- Spell number in excel without macro - Guide
- How would you change all cells containing the word pass to green - Excel Forum
- Macro excel download - Download - Spreadsheets
- Sum in french excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 12, 2010 at 05:39 PM
Apr 12, 2010 at 05:39 PM
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
Now to find cost of dairy products you can have this formula
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)