Hammerhance
New Member
- Joined
- Oct 13, 2017
- Messages
- 9
hi there,
I am using INDEX MATCH to identify a range of figures across sheets, but I'm having difficulty then adding in SUMIF to calculate multiple occurances.
This sheet is 'Events' and the formula I am using in column E is =INDEX('2013'!D:D,MATCH(Events!A5,'2013'!A:A,0))
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
The figure in column E on the first sheet, should read £3920, the sum of the above two figures, but I can't get the formula to work.
Please can someone help
Many thanks
I am using INDEX MATCH to identify a range of figures across sheets, but I'm having difficulty then adding in SUMIF to calculate multiple occurances.
This sheet is 'Events' and the formula I am using in column E is =INDEX('2013'!D:D,MATCH(Events!A5,'2013'!A:A,0))
Advanced Engineering | NEC | November | £4,355 | £4,355 |
AP&M | Olympia | May | £10,730 | £10,730 |
Autumn Furniture Show | Stonleigh Park | October | £0 | #N/A |
BETT | Excel | January | £13,275 | £13,275 |
Biofuels Expo | Stoneleigh | September | £3,920 | £2,985 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
This sheet is '2013'
<colgroup><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
The figure in column E on the first sheet, should read £3920, the sum of the above two figures, but I can't get the formula to work.
Please can someone help
Many thanks