Prev: Summing Cells with Text and Numbers
Next: Excel 2007: Conditional Formatting and Ribbon Data
From: gp on 17 Mar 2010 12:49
I have multiple instances on my spreadsheet of the same part number that I am
tracking. In the differernt lines I have the different quantities of the same
part number. I want to ultimately pull them together to get a TOTAL, how do I
do this?
From: Pete_UK on 17 Mar 2010 13:40
You might want to do it on a separate sheet, where you can list the
different part numbers once in column A. Then in B1 you can have this
formula:

=SUMIF(Sheet1!part_num,A1,Sheet1!quant)

where part_num is the column that you have your part numbers in on
Sheet1, eg E:E, and quant is the column where the individual
quantities are found on Sheet1, eg M:M. You can use full-column
references with SUMIF. Then just copy the formula down to get summary
totals for each part number.

Hope this helps.

Pete

On Mar 17, 4:49 pm, gp <g...(a)discussions.microsoft.com> wrote:
> I have multiple instances on my spreadsheet of the same part number that I am
> tracking. In the differernt lines I have the different quantities of the same
> part number. I want to ultimately pull them together to get a TOTAL, how do I
> do this?

From: Ashish Mathur on 17 Mar 2010 19:25
Hi,

You may create a pivot table. Drag part number to the row area and
quantities to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"gp" <gp(a)discussions.microsoft.com> wrote in message
news:8BD3D011-4C91-47D8-81A1-E68ED036B207(a)microsoft.com...
> I have multiple instances on my spreadsheet of the same part number that I
> am
> tracking. In the differernt lines I have the different quantities of the
> same
> part number. I want to ultimately pull them together to get a TOTAL, how
> do I
> do this?

 | 
Pages: 1
Prev: Summing Cells with Text and Numbers
Next: Excel 2007: Conditional Formatting and Ribbon Data