Thanks everyone. One simple little open paren.

"Johnnie" wrote:

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