Hello everyone,
I am desperate with this challenge.
1
3
4
3
4
3
6
5
5
2
I need to sum the above column with the below criteria:
1. Sum values only once (as some values will be duplicated)
2. The value must be more than 3.
So I need it as 4+5+6=15
I was able to satisfy the first condition by using sumproduct and countif. But I was not able to fit in the 2nd criteria.
Can you please help?
Thank you in advance!
I am desperate with this challenge.
1
3
4
3
4
3
6
5
5
2
I need to sum the above column with the below criteria:
1. Sum values only once (as some values will be duplicated)
2. The value must be more than 3.
So I need it as 4+5+6=15
I was able to satisfy the first condition by using sumproduct and countif. But I was not able to fit in the 2nd criteria.
Can you please help?
Thank you in advance!