• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiply values based on criteria

polarisking

polarisking

Member
Similar to SUMPRODUCT which adds, is there a way to multiply values based on criteria?

For example, for every value of D in column BenchUpDown (Column F), I'd like to add 1 and multiply the values in Port(Column C). See the attached file.

Ideally, I'd like to avoid the helper column in the file (Column G). Many thanks, in advance.


upload_2016-11-15_9-40-41.png
 

Attachments

  • ChandooMultiplyBasedOnCriteriaExample.xlsx
    11.6 KB · Views: 3
polarisking said:
Similar to SUMPRODUCT which adds, is there a way to multiply values based on criteria?

For example, for every value of D in column BenchUpDown (Column F), I'd like to add 1 and multiply the values in Port(Column C). See the attached file.

Ideally, I'd like to avoid the helper column in the file (Column G). Many thanks, in advance.


View attachment 36129
Click to expand...
Hi @polarisking

Something like (see attached... cell J13. Formula must be inserted with Ctrl+Shift+Enter)
 

Attachments

  • ChandooMultiplyBasedOnCriteriaExample.xlsx
    11.9 KB · Views: 14
You must log in or register to reply here.
Back
Top