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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks