Can array have to conditions to meet before summing the numbers?

[Oberon70]

I have a table with 8,000 transactions, The reference number can appear on several transactions. I am wanting to sum the amount and commission based on the claim number and the invoice number.

Example:

The below has the same claim number but there are different invoices numbers

The end result would be

I have arrays that I have been provided which works great with summing the reference number and then the amounts, but not the above.

thanks,

 

[etaf]

Sorry - i missed the XL2BB , looks different for some reason on my PC , and usually the copy icon at top, so didnt scroll down enough
So really sorry i missed that

 

[Oberon70]

It is not a problem, I really appreciate the help you gave with the formulas. I was able manually complete the batch reports with it.

 

[etaf]

so you are all sorted now
glad to hear