How to sum values based on multiple array values?

Hi guys

I hope you can help me make a nice solution for this one.

In the enclosed spreadsheet I am trying to sum the total sum range of column B where the value in column A is equal to a value in column C.

I can express this in a SUMIF function as such: =SUMIF(A:A;C:C;B:B). The only problem with this is that I have to drill down with the formula so that it checks each criteria cell. I would like for it to sum it up in total in cell I have picked for the formula (f2 in my spreadsheet).

Maybe sumproduct could be of help but I have not been able to make it work...

Do any of you guys know of an easy solution?

Thanks in advance
Kind regards
Morten

Originally Posted by Glenn Kennedy

Hi. Try this:

=SUMPRODUCT($B$2:$B$21*COUNTIF($C$2:$C$3,$A$2:$A$21))

You may need ; instead of ,

Thanks for the suggestion, but sadly this does not work for me as it multiplies the result according to the number of cells populated. Thanks anyways though