Posted to microsoft.public.excel.worksheet.functions

irvine79

external usenet poster

Posts: 21

Sumif question - I think?

Column A contains part #s that are listed a varying amount of times
F8Z100
F8Z100
F8Z101
F8Z102
F8Z102
F8Z102
F8Z102

Colum B contains a value associated with the part # in column A
10
15
12
15
11
9
3

In Column C I want a formula that totals the values from Column B if they
have the for the same part # in Column A. (Desired result below)
25
12
-
-
-
38

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIF question	Shan	Excel Discussion (Misc queries)	1	December 3rd 06 03:34 AM
Question about SumIF	zhuanyi	Excel Worksheet Functions	3	August 11th 06 04:39 AM
SUMIF Question	Brig Siton	Excel Worksheet Functions	3	January 25th 06 05:16 PM
Sumif question	J Shrimps, Jr.	Excel Worksheet Functions	5	January 20th 06 05:26 PM
SUMIF question	alice	Excel Discussion (Misc queries)	2	November 24th 05 02:55 PM

All times are GMT +1. The time now is 10:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us