# SExcel Question

**URL:** <https://forums.speedlife.net/t/sexcel-question/75253>\
**Category:** NYSpeed Off Topic\
**Created:** [October 23, 2009, 7:06am UTC](https://forums.speedlife.net/t/sexcel-question/75253 "2009-10-23T07:06:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![walter](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/walter/32/7202_2.png) [@walter](https://forums.speedlife.net/u/walter)\
**Post date:** [October 23, 2009, 7:06am UTC](https://forums.speedlife.net/t/sexcel-question/75253/1 "2009-10-23T07:06:03Z")

</div>

Brain not working on Friday.

I have a spreadsheet that among other things contains a column of component part numbers, and a column of quantities.

I’d like to get the total quantities of each component. What do I need to stick in the Total Qty column to get it to calculate?

![http://www.nyspeed.com/forums/attachment.php?attachmentid=10859&stc=1&d=1256306749](http://www.nyspeed.com/forums/attachment.php?attachmentid=10859&stc=1&d=1256306749)

It is a much larger list, but the attached gives a simple example of what I’m talking about.

I can do it very manually, but I’d rather not.

---

<div class="post-metadata">

**Author:** ![Joe](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/joe/32/7219_2.png) [@Joe](https://forums.speedlife.net/u/Joe)\
**Post date:** [October 23, 2009, 7:11am UTC](https://forums.speedlife.net/t/sexcel-question/75253/2 "2009-10-23T07:11:42Z")

</div>

Why not just make a pivot table with component and sum of quantity?

---

<div class="post-metadata">

**Author:** ![Fry](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/fry/32/7284_2.png) [@Fry](https://forums.speedlife.net/u/Fry)\
**Post date:** [October 23, 2009, 7:14am UTC](https://forums.speedlife.net/t/sexcel-question/75253/3 "2009-10-23T07:14:11Z")

</div>

Word. Pivot table.

---

<div class="post-metadata">

**Author:** ![Paulo](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/paulo/32/7328_2.png) [@Paulo](https://forums.speedlife.net/u/Paulo)\
**Post date:** [October 23, 2009, 7:22am UTC](https://forums.speedlife.net/t/sexcel-question/75253/4 "2009-10-23T07:22:45Z")

</div>

x3

---

<div class="post-metadata">

**Author:** ![walter](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/walter/32/7202_2.png) [@walter](https://forums.speedlife.net/u/walter)\
**Post date:** [October 23, 2009, 7:37am UTC](https://forums.speedlife.net/t/sexcel-question/75253/5 "2009-10-23T07:37:44Z")

</div>

That is what my brain couldn’t remember this morning… pivoting.