To *array-enter* a formula, after typing or copying it in, hold down
<ctrl><shift> while hitting <enter>. XL will place braces {...} around the
formula.
=sumproduct((rngA="x")*(rngB="Y")*rngC)
NOT necessary to array enter
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.