Specifically, how do you determine that the value is 4 for the first row, 5
for the second?

Barb Reinhardt



"Greg" wrote:

Each cell would have the same formula, except it looks for 2, then 3, then 4

"Barb Reinhardt" wrote:

It's not clear to me how you get 4, 5, 6 or 8 for column C. Please advise
and I can give more suggestions.

Barb Reinhardt



"Greg" wrote:

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