Array Function?

[Johnnie]

A B C
1 Company 1 10 Company 1
2 Company 2 10
3 Company 3 10
4 Company 2 8
5 Company 1 7
6 Company 1 6
7 Company 3 8

In C2 I am using this function =sumproduct(--$a$1:$a$7="Company 1"),b1:b7)
I keep getting an error and I am not sure what I am missing. Any help is
great appreciated.

Johnnie

 

[Don Guillett]

=sumproduct(($a$1:$a$7="Company 1")*b1:b7)
or
=sumproduct(--($a$1:$a$7="Company 1"),b1:b7)

 

[Mike H]

Hi,

try this

=SUMPRODUCT(--($A$1:$A$7="Company 1"),B1:B7)

or this

=SUMPRODUCT((A1:A7="Company 1")*(B1:B7))

Mike

 

[Eduardo]

Hi,
very close

=sumproduct(--($a$1:$a$7="Company 1"),$b$1:$b$7)

 

[Johnnie]

Thanks everyone. One simple little open paren.