Sumproduct

S

Steved

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

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

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.

:
Click to expand...

--

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

Steved

Thankyou Aladin

Aladin Akyurek said:
=SUMIF($C$4:$C$15,"S",$H$4:$H$15)
=SUMIF($C$4:$C$15,"P",$H$4:$H$15)
Thanks very much.

:
Click to expand...

--

[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.
Click to expand...
 
Top