T-Shirt Order Form

**soaringusaeagle** · 08-13-2017, 12:56 PM

We are submitting a T-shirt order and I want to automate the "total" column with pricing.

Short sleeve S-XL shirts are $20
Short sleeve 2XL-3XL shirts are $25

Long sleeve S-XL shirts are $30
Long sleeve 2XL-3XL shirts are $35

What would be the easiest way to accomplish?

Thank you for the help!

**shg** · 08-13-2017, 01:29 PM

	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Short Sleeve						Long Sleeve						Total
2	20	20	20	20	25	25	30	30	30	30	35	35
3	S	M	L	XL	2XL	3XL	S	M	L	XL	2XL	3XL
4			1										$20	O4: =SUMPRODUCT($C$2:$N$2, C4:N4)
5				1						1			$50
6				1									$20
7			1										$20

**soaringusaeagle** · 08-13-2017, 04:26 PM

Thank you very much! I didn't think about adding a new row and then just hiding it. I was trying to put values on the sizes and make it way more complicated.

**shg** · 08-13-2017, 05:10 PM

You're welcome.

T-Shirt Order Form

LinkBack

Thread Tools

Rate This Thread

Display

T-Shirt Order Form

Re: T-Shirt Order Form

Re: T-Shirt Order Form

Re: T-Shirt Order Form

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Submit Order Button not working in my Excel Spreadsheet Order Form

[SOLVED] Order Form to Summarise Order on another sheet with a Submit Order Button

[SOLVED] T-Shirt Order Lists

Need help with a function to add up shirt orders

Want to auto-populate an order form from a storeroom count form

Shirt sizing and numbering

[SOLVED] Need help with Pivot Table for t-shirt counts

Bookmarks

Bookmarks

Posting Permissions