Formula to Calculate criteria and sum results in cell

[Foreverlearning]

Hi,

In what I am trying to achieve is a formula to work out results between 3 columns for a match and sum all similar in another cell.

I have attached a small example and marked "Here is where I am asking for a formula'' as to where I am referring too.

Basically Look for same Types in all lines and Multiply -- J column by F column and G column and sum all same types in cell referenced below

Thanks
Lionel

[zbor]

Try this in J24 and drag down:

=SUMPRODUCT(--($I$5:$I$21=B24),$F$5:$F$21,$G$5:$G$21,$J$5:$J$21)/1000

[Foreverlearning]

Hi zbor,

Thanks for your solution.

It works just right but a question.

A lot of data being in none contiguous cells (Gaps with other data between that has no relationship to required info)
Does that have any impact on results or would you say that because it does not match criteria you can have what you like in between?

Thanks
Lionel

[zbor]

Doesn't matter. As long as you define Teams1,2,3 and refer to them it will look only that and ignore other data. Even text.

[Foreverlearning]

Hi zbor,

Thank you very much for your responses.
Your help is very much appreciated.

Lionel