greentree0021
New Member
- Joined
- Aug 14, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I have used the below function to add only those numbers from France!AQ5:AQ213 that contains either "C4" or "C 4" in France!AP5:AP213.
=SUM(SUMIFS(France!AQ5:AQ213,France!AP5:AP213,{"C4","C 4"}))
Now, I wish to add one additional criteria:
Thanks.
=SUM(SUMIFS(France!AQ5:AQ213,France!AP5:AP213,{"C4","C 4"}))
Now, I wish to add one additional criteria:
- add only those numbers from France!AQ5:AQ213
- contains either "C4" or "C 4" in France!AP5:AP213
- AND contains either "a" or"A" in France!D5:D213
Thanks.