Array Function?
 

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

Array Function?
 

=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

Array Function?
 

Hi,

try this

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

or this

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

Mike

"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

Array Function?
 

Hi,
very close

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

"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

Array Function?
 

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