I have to do a conditional sum which has several conditions.
For the complete situation see the attached file.
The evaluation what should be done is as follows:
If count of a specific sofi number > 1
if count "ind. act" = J for that same sofi number > 1
Fixed text: "Manual check"
sum column C for the selected sofi number where "ind act" = J
sum column C for the selected sofi number regardless of the value of "ind act"
My problems lies in the second IF. I think I have to do something with AND but I cannot think of a way to do a count on "ind act" where sofi number has a specific value.
Also I need to find a way to select the correct row if there is a J and N value in "ind act".
Can anyone help me?