Thread: Sumproduct
View Single Post
  #1   Report Post  
Steved
 
Posts: n/a
Default 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.