SUMIF? help

**ApexClip** · 03-26-2009, 02:20 PM

Heres my problem, probably simple but I'm not too familiar with excel.

If the characters (ex: IN3040) in cells A1:A10 are the same. I need it to add the numbers from B1:B10 of its row, into another cell.

**NBVC** · 03-26-2009, 02:22 PM

you mean?

=Sumif(A1:A10,"IN3040",B1:B10)

**ApexClip** · 03-26-2009, 02:27 PM

the "IN0000" was an example of codes within colulmn A ex:

A B C
IN123 30% =total
IN456 20%
IN123 10%
IN456 20%
IN123 30%

i need a formula where it will add up the percents in column B of the same codes from column A i'm trying my best to explain, sorry.

so, IN456 would give =40%

and IN123 would give =70%

**ConneXionLost** · 03-26-2009, 02:31 PM

Place in cell C1

Please Login or Register  to view this content.

then copy down

**NBVC** · 03-26-2009, 02:31 PM

So if you have the unique codes setup in say column C then you would put in column D

=Sumif($A$1:$A$10,C1,$B$1:$B$10) and copy down.. it will sum column B only where column A equals C1...

Or you could use Pivot tables to do the work for you...

or you can get a unique list through Data|Filter|Advanced Filter... and then use Sumif() as above.