Multiple "IF" formula issue

[garymu16]

=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.

 

[barry houdini]

Are you using that exact formula? Most probable causes of #REF! here are misspelling of worksheet name or #REF errors within the referenced ranges

 

[garymu16]

Yip - Cut and paste

 

[Brian from Maui]

Does D2:D65000 contain text? Do you really have 65000 rows of data?

 

[barry houdini]

Here's a working example - I swapped G6 for B1 so that I could have it all on one sheet but otherwise formula in C1 is the same as above

=SUMPRODUCT(--(pipeline!A2:A65000=B1),--(pipeline!G2:G65000>79),pipeline!D2:D65000)

Book1
	A	B	C	D	E	F	G	H
1		barry	9
2	barry			1			77
3	dave			2			78
4	barry			3			79
5	barry			4			80
6	barry			5			81
7	steve			6			82
8	phil			7			83
9
pipeline

 

[garymu16]

Great! Works a treat.

What does the -- signify?