I think Roger meant:

=SUMPRODUCT(--($B$1:$B$5="Orange"),--($C$1:$C$5="Blue"),$A$1:$A$5)

--
Jim
"James Hamilton" wrote in message
...
| Sum product is not working..... coming up with "0".
|
| Any other ideas?
|
| "Roger Govier" wrote:
|
| Hi James
|
| One way
| =SUMPRODUCT(--($B$2:$B$5="Oranges"),--($C$2:$C$5="Blue"),$A$1:$A$5)
|
| Regards
|
| Roger Govier
|
|
| James Hamilton wrote:
| Hi,
|
| I want to do a SUMIF but on more than one condition. For example:
|
| A B C
| 3 Apple Green
| 4 Orange Blue
| 4 Pear Yellow
| 5 Orange Blue
| 6 Orange Red
|
| I want to sum the amounts in column A, based on column B and C. In
this
| case, sum the amounts in column A for Oranges in column B and Blue in
Column
| C.
|
| Any help would be appreciated.
|
| James
|
|