SUMIF Formula Help

S

s boak

Hi Folks:
I have a small table (C4:G85)
Col. C is part numbers
D-E-F are quantities
Col. G is total quantity

I'm trying (with no luck) to get a formula that will add the qtys of all
part numbers that contain CU16

I'm using (entered as array)
=SUM(IF(C4:C79="CU16",G4:G79))

Would appreciate any guidance.
Many thanks.
Steve
 
D

Dave Peterson

Your formula looks ok to me, but I think I would have used:

=SUMIF(C4:C79,"CU16",G4:G79)
(Not array entered)

But if your formula fails, then mine will too.

Are you sure that you have a cell in c4:c79 that contains CU16 (no
leading/trailing spaces allowed) and you have numbers in G4:G79 (maybe they're
not numbers, but text).
 
S

s boak

Thanks so much Dave
Very much appreciate the help - and keeping some hair.
Steve
 
Top