Is a multiple SUMIF formula possible in Excel 2003?

After searching the forum it seems that what I need is SUMIFS, but that's not available in my rather dated version of Excel.

I need a SUMIF formula that will return a total from Col.I only if specified conditions are met in both Col.J and Col.K.

I've attempted to attach a copy of the worksheet, which is a list of wiring required to make up a harness (loom) for a car. Cell W21 contains a single SUMIF formula, but it needs to be combined with the formula in X21, in other words both cable size (Col.J) and colour (Col.K) coincide.

Any help with this will be greatly appreciated.

Richard

Sorry, but I don't understand how this can serve the purpose. I looked at SUMPRODUCT but discarded it because it multiplies.
I need to add the corresponding values in Col.I.

The Excel helps says this:

"Multiplies corresponding components in the given arrays, and returns the sum of those products."

It also says: "SUMPRODUCT treats array entries that are not numeric as if they were zeros."

Obviously this won't work when the criteria are text, not numeric.

Would an array formula of some kind work, perhaps?

Brilliant, Tony—many thanks indeed. I did try your suggestion but omitted the hyphens (-) because I didn't realise they were part of the formula.

What exactly is their function? It's important that I understand how this works.

Thanks again for your help.

Thanks again, Tony, for the clear explanation and also for the link. I had no idea Excel functions could be manipulated in so many ways, thus keeping my outdated version alive.

Cheers,

R.