It worked out perfect, I forgot the sumproduct function...thanks

"Ron Coderre" wrote:

With your sample data in A1:C4

Try this:
E1: (the combo to find.....eg "MOTOROLA JXP 1")

This formula returns the sum of Col_C values associated with that combo:
E2: =SUMPRODUCT(--(A1:A4&" "&B1:B4=E1),C1:C4)

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Greg" wrote in message
...
Looking to sumif A1 and B1 = "MOTOROLA JXP1" then C1 would be the anwser

A B C
1 MOTOROLA JXP 1 4
2 MOTOROLA JXP 2 5
3 MOTOROLA JXP 3 6
4 MOTOROLA JXP 4 8


Thanks, Greg