Sumproduct

[Guest]

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.

 

[ScottO]

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


| 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.

 

[Guest]

Thanks very much.

 

[Aladin Akyurek]

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

Thanks very much.

:

--

[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.

 

[Guest]

Thankyou Aladin

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

Thanks very much.

:

--

[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.