Sumif with different tab

[wiewie002]

Hi All
I'm having trouble with combined 3 columns into 1 column.
Please help to advise which formula need to get total incoming in column D4.
I’d really appreciate any help or advice you can offer.

Sumif for total.xlsx

Cheers- Wie

[thecat1863]

It may be that you have merged the cells in row 1, you may need to manually go in and amend the formula, so that it looks something like this
=SUMIF('RM1'!C:C,Total!C3,'RM1'!D:D)+SUMIF('RM1'!C:C,Total!C3,'RM1'!E:E)+SUMIF('RM1'!C:C,Total!C3,'RM1'!F:F)
Hope this helps

The Cat

[Glenn Kennedy]

It took me a while to realise that the reason that answer was 0 in all cells was that your codes weren't the same (11 on one sheet, 111 on the other). Try this:

=SUMPRODUCT(('RM1'!$B$3:$B$12=Total!B3)*'RM1'!$D$3:$F$12)