Thank you for the help. It is greatly appreciated. I have a couple of
questions... pasting the first formula gets me the SKU information;
however,t he second formula does not generate any information. What exactly
is the second formula calculating (which data)?

When pasting this formula, will I need to paste it in a cell for each
different SKU or is there a way to automate this entry?
--
J. Paul Long
Training Manager


"Kleev" wrote:

I modified something I was using which was similar (except I was just doing
counts.) If you don't mind the information being in 2 columns and the SKU
being listed first instead of last like so:

30478FJYPK20MIN EA 275 30478FJYPK20MIN 384
30478FJYPK20MIN EA 21
30478FJYPK20MIN EA 85
30478FJYPK20MIN EA 3
30518FRTRP SET 2 30518FRTRP 2
30518FRTRPHC SET 4 30518FRTRPHC 4
3068FM100 EA 358 3068FM100 366
3068FM100 EA 8
3068SPEM4P EA 112 3068SPEM4P 112
3068SPEM4P20MIN EA 275 3068SPEM4P20MIN 363
3068SPEM4P20MIN EA 85
3068SPEM4P20MIN EA 3
3068SPEN4P20MIN EA 21 3068SPEN4P20MIN 21

Also notice I did not put in the = sign. I'm sure I could have using the
concatenation symbol (&), but just in case you wanted to use the numbers as
numbers, I figured if you really wanted, you could use a column with a very
small width and put the "=" sign there.
The two formulas a
=IF(COUNTIF(OFFSET(D$2:D3,-1,0),A3)0,"",A3)
=IF(COUNTIF(A$3:A$15,D3)0,SUMIF(A$3:A$15,D3,$C$3: $C$15),"")
Note: It appears that you need to put those formulas in rows 3 or below or
you will get a bunch of #REF errors.

"JP Long" wrote:

The data below shows a section of the information we are trying to subtotal.
What I am looking for is a formula (or combination of formulas) that will
provide a subtotal for each specific item listed. An example is illustrated
on the first two SKUs.


30478FJYPK20MIN EA 275
30478FJYPK20MIN EA 21
30478FJYPK20MIN EA 85
30478FJYPK20MIN EA 3 30478FJYPK20MIN = 384
30518FRTRP SET 2
30518FRTRPHC SET 4 30518FRTRP = 6
3068FM100 EA 358
3068FM100 EA 8
3068SPEM4P EA 112
3068SPEM4P20MIN EA 275
3068SPEM4P20MIN EA 85
3068SPEM4P20MIN EA 3
3068SPEN4P20MIN EA 21

I think what I want to do is search the sheet for each specific item and
then have the formula calculate a total for all the like SKUs...? I'm
totally lost on what will work...
--
J. Paul Long
Training Manager