Should they be like this?
=SUMPRODUCT(--($C$4:$C$15="S"),$H$4:$H$15)
=SUMPRODUCT(--($C$4:$C$15="P"),$H$4:$H$15)
Rgds,
ScottO
"Steved" wrote in message
...
| Hello from Steved
|
| =SUMPRODUCT(--($C$4:$C$15),--($H$4:$H$15=S))
| =SUMPRODUCT(--($C$4:$C$15),--($H$4:$H$15=P))
|
| Column C has S and P
| Column H has the value I need to total.
|
| What Have I done wrong Please.
|
| Thankyou.
|