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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Johnnie" wrote in message
...
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