Adding specific values in different columns using one formula

Below is a picture of my issue. How would I go about finding the "Number of Shirts Ordered" values in the top right?

http://gyazo.com/6e1f944c9da97000f94f4cd86beb64e0

Thanks in advance.

The picture does not fit perfectly to title: "Adding specific values in different columns using one formula"

I assumed that picture describes problem better than title.
Use function SUM and show the column with orders
shall look in formula bar similar to:

=SUM(G:G)

PS. Read Want to get your question answered quickly? (and whole document too) in our rules: http://www.excelforum.com/forum-rule...rum-rules.html