Adding muliple sum formulas in one column
Closed
Noah
-
Nov 16, 2009 at 12:07 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 16, 2009 at 08:51 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 16, 2009 at 08:51 PM
Related:
- Adding muliple sum formulas in one column
- Little alchemy formulas - Guide
- Vba find column by name ✓ - Excel Forum
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Sum column if another column equals ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Nov 16, 2009 at 08:51 PM
Nov 16, 2009 at 08:51 PM
I suggest the following.
first in the same sheet or in separate sheet
list the unique order names by using advance filter
then you can use COUNTIF function or SUMPRODUCT function. read
help on these fucntions and also advance filter method.
first in the same sheet or in separate sheet
list the unique order names by using advance filter
then you can use COUNTIF function or SUMPRODUCT function. read
help on these fucntions and also advance filter method.