krishcrash
New Member
- Joined
- Jun 12, 2018
- Messages
- 1
I have a simple spreadsheet that is referencing data that is currently not working (See below).
RESULTS
<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
<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
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