tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,195
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I use sumifs and countifs a lot, one of the things i'd like to do is include a sumifs and a countifs that includes mutiple critieria, let me explain
So Column J is a persons name
and Column F is the areas he works in.
So If i want to see how James has done in Essex I would put
=Sumifs(B:B,J:J,"James",F:F,"Essex")
But how can i do this for both Essex and Sussex (for example)
please help if you can
Thanks
Tony
I use sumifs and countifs a lot, one of the things i'd like to do is include a sumifs and a countifs that includes mutiple critieria, let me explain
So Column J is a persons name
and Column F is the areas he works in.
So If i want to see how James has done in Essex I would put
=Sumifs(B:B,J:J,"James",F:F,"Essex")
But how can i do this for both Essex and Sussex (for example)
please help if you can
Thanks
Tony