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

		Jan	Feb	Mar	Apr	May	Jun	Jul...
London
	Liam	--*	--	--	--	--	--	--

<tbody>
</tbody>

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

Place	Person	Jan	Feb...
London	Liam	1	2
London	James	3	4
Birmingham	Frank	5	6
Manchester	Liam	7	8
London	Liam	9	10

<tbody>
</tbody>

* 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)