Sumproduct
 

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.

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.

Thanks very much.

"ScottO" wrote:

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.

=SUMIF($C$4:$C$15,"S",$H$4:$H$15)
=SUMIF($C$4:$C$15,"P",$H$4:$H$15)

Steved wrote:
Thanks very much.

"ScottO" wrote:


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.




--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

Thankyou Aladin

"Aladin Akyurek" wrote:

=SUMIF($C$4:$C$15,"S",$H$4:$H$15)
=SUMIF($C$4:$C$15,"P",$H$4:$H$15)

Steved wrote:
Thanks very much.

"ScottO" wrote:


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.




--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.