Is there a macro which will sum cells
Closed
nina
-
Apr 12, 2010 at 05:26 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 12, 2010 at 05:39 PM
rizvisa1 Posts 4479 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
- Run macro when cell value changes - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Automatically Run Macro from a calculated cell value change ✓ - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Spell number in excel without macro - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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)