Simple SUMIFS going wrong - I'm doing something dumb

[krishcrash]

I have a simple spreadsheet that is referencing data that is currently not working (See below).

RESULTS

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul...[/TD]
[/TR]
[TR]
[TD]London[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Liam[/TD]
[TD]--*[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[TD]--[/TD]
[/TR]
</tbody>[/TABLE]


The data is set out such that their are several people making sales from different areas and I just need to sum the sales in January from Liam in London.

DATA

[TABLE="width: 500"]
<tbody>[TR]
[TD]Place[/TD]
[TD]Person[/TD]
[TD]Jan[/TD]
[TD]Feb...[/TD]
[/TR]
[TR]
[TD]London[/TD]
[TD]Liam[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]London[/TD]
[TD]James[/TD]
[TD]3[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Birmingham[/TD]
[TD]Frank[/TD]
[TD]5[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]Manchester[/TD]
[TD]Liam[/TD]
[TD]7[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]London[/TD]
[TD]Liam[/TD]
[TD]9[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

* My idea to fill in Jan data for Liam was to use SUMIFS (=SUMIFS('DATA'!C:C, 'DATA'!A:A, "='Results'!A2",'DATA!B:B,"='RESULTS'!B3") however this isn't working - am I doing this completely wrong?

Any help would be great.

Thanks

 

[Jonmo1]

Welcome to the board.

Try

=SUMIFS('DATA'!C:C, 'DATA'!A:A, 'Results'!A2,'DATA'!B:B,'RESULTS'!B3)