Kellibelle
New Member
- Joined
- Jun 8, 2018
- Messages
- 2
Hi I wonder if anyone can help please I am looking for a way to sum the number of days in a column if it meets the criteria in another column and for the life of me I cant get my head around it. So for example if it is "Category 1 - minor" in one column I want it to sum the number of days in the next Column (it would be 21 days in this case) but how do I set a formula up to do that?
AdType 1 Days
Category 3 - major 3
Category 1 - minor 7
Category 1 - minor 7
Category 1 - minor 7
Category 2 - moderate 10
AdType 1 Days
Category 3 - major 3
Category 1 - minor 7
Category 1 - minor 7
Category 1 - minor 7
Category 2 - moderate 10