KATYCUSHEN
New Member
- Joined
- Sep 9, 2019
- Messages
- 2
I am struggling with creating a formula that works for the below scenario
<tbody>
</tbody>
I have two sheets in one workbook. One with full budget data with in this scenario a Budget v1 and Budget v2 along with individual item names
I want to set up a formula in a separate sheet to input the correct number based on two criteria, the specific item name and the specific budget number
I can get SUM IF to work if there is only one criteria but not both. I have also tried SUMPRODUCT and INDEX MATCH scenarios but not successfully!
I also want to avoid writing "Item A" as this formula will need to scan hundreds of lines of data - all individually named
All help appreciated
A | B | C | |
1 | Item | Budget v1 | Budget v2 |
2 | Item A | 50 | 55 |
3 | Item B | 60 | 65 |
4 | Item C | 70 | 75 |
5 | Item D | 80 | 85 |
<tbody>
</tbody>
I have two sheets in one workbook. One with full budget data with in this scenario a Budget v1 and Budget v2 along with individual item names
I want to set up a formula in a separate sheet to input the correct number based on two criteria, the specific item name and the specific budget number
I can get SUM IF to work if there is only one criteria but not both. I have also tried SUMPRODUCT and INDEX MATCH scenarios but not successfully!
I also want to avoid writing "Item A" as this formula will need to scan hundreds of lines of data - all individually named
All help appreciated