• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MS excel gurus - help needed

W

wedi42

Platinum Member
i'm looking for an easy way to add up some totals for tshirt orders.
i have 1 column with size eg. small, medium, large
and another column with quanity
is there a way for excel to give me totals
eg.
small 42
med 120
large 56
etc..

there are over 210 lines i'm afraid i'll make a mistake if i try to do this manually

a pic of spreadsheet
 
I think the fastest way would be to sort by the shirt size column and then just use several sum() functions.
 
1. Highlight the entire range of data

2. From the menu bar Data/sort, select the size column as the sort criteria hit OK

3. From menu bar Data/subtotal, select the size column hit OK

You can control what displays in the spreadsheet by clicking 1,2,or 3 on the left side

1 displays only the grand total
2 displays only the sub-totals
3 displays all the data, subs, and grand total
 
ya, it's easy. copy it to a different worksheet. Sort by size. then just use the sum command after each size for the quantity column.

send it to me and i'll do it for you in 3 minutes - you don't even have to send me the name/address stuff, just those 2 columns.
 
I would also seperate them out to their own tabs and then link the totals to the other pages in your workgroup. I know it sounds more complicated and might even be a bit more, but it will definitely keep your information seperate, but still be able to keep basic things like how many shirts total regardless of what size.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top