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
Related:
- Is there a macro which will sum cells
- Spell number in excel without macro - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Macro excel download - Download - Spreadsheets
- Which example represents cell data with the date format applied to it? - Excel Forum
- Count if there is a number in the cell - Excel Forum
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)