mountainman88
Board Regular
- Joined
- Jun 22, 2019
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
I have been able to SUMPRODUCT a total amount in cell E4 using text entered into cells F1 and F2 to create conditions. How do I modify the formula so that if F1 contains the text "Total", that the conditions for the SUMPRODUCT are "Yes" AND "No", and if cell F2 contains the text "Total" the conditions for the SUMPRODUCT are "COS" AND "SGA" AND "Revenue"?
Thank
Thank
A | B | C | D | E | F | |||||||
1 | PL | AMT | IT? | Yes/No/Total | ||||||||
2 | Yes | COS | 50000 | PL | COS/SGA/Revenue/Total | |||||||
3 | Yes | SGA | 10000 | |||||||||
4 | No | SGA | 20000 | Result: | =SUMPRODUCT((C2:C5),--(A2:A5=F1),--(B2:B5=F2)) | |||||||
5 | Yes | Revenue | 40000 | |||||||||