Obewan
Board Regular
- Joined
- Aug 25, 2021
- Messages
- 68
- Office Version
- 365
- Platform
- Windows
I am trying to write the following formula (have tried sumifs but can't get it right) - i.e. if both words appear in columns AB and AC then it will total the corresponding number column AB
=sumif(AB9:AB2000,"Lay",AC9:AC2000,"Lay1",AE9:AE2000)
Thanks
=sumif(AB9:AB2000,"Lay",AC9:AC2000,"Lay1",AE9:AE2000)
Thanks