=sum(IF((Pipeline!A2:A65000,$G$6)*(Pipeline!G2:G65000>79), Pipeline!D2:D65000))
Can anyone see where I'm going wrong here?
The first two commands I'm trying to establish are
1. Does the name match $G$6
And
2. Does it also have a probability higher than 79
If so sum range D2:D65000 for all info that meets the two criteria.
Can anyone see where I'm going wrong here?
The first two commands I'm trying to establish are
1. Does the name match $G$6
And
2. Does it also have a probability higher than 79
If so sum range D2:D65000 for all info that meets the two criteria.