Tennisguuy
Well-known Member
- Joined
- Oct 17, 2007
- Messages
- 562
- Office Version
-
- 2016
- Platform
-
- Windows
I have a formula in cell H24 that sums the values in H6:H22. In cell I24 I would like to sum the same values but exclude a couple of cell and put the work Package in parenthesis.
I used the following formula and it works the way I want but I can't format it to show total with commas in the number
This is the formula I have in cell I24 SUM(H25-H10-H12)&""&"(Package)". Can you format with this type of formula
I used the following formula and it works the way I want but I can't format it to show total with commas in the number
This is the formula I have in cell I24 SUM(H25-H10-H12)&""&"(Package)". Can you format with this type of formula