How do I create a formula for summing the product of cells, based on their value? [duplicate]

excel excel-formula

Below should work

=SUMPRODUCT((A2:A6)*(B2:B6)*(B2:B6>1))

Use the FILTER() function, using the 2nd column as the test.

=SUM(FILTER(A1:A5*B1:B5,B1:B5>1))

enter image description here


I found another solution that I have somehow missed before

=SUMPRODUCT( --(B1:B9 > 1), A1:A9, B1:B9)

Related

ESOCKETTIMEDOUT error while yarn install command
What is the main differences (pros v. cons) of designing a simple linked button by <a> tag instead of <button> tag? [duplicate]
Apache2: Cannot access Userdir - Forbidden
trying to convert functions to c++ how do I change target to scene component
Why does this variable only work inside a function?
The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 6A030B21BA07F4FB
Forward local port or socket file to remote socket file
Rsync command issues, owner and group permissions doesn´t change
High CPU utilization but low load average
Do all servers need to use the HTTPS protocol or just public facing servers?
Users with Google's IP address. How is it possible?
Should dev be admin on their computer? [closed]