Question: A formula in excel that will look up values that sum up to a specific number without using solver. For example: column A has 2,6,8,5,9,10

A formula in excel that will look up values that sum up to a specific number without using solver. For example: column A has 2,6,8,5,9,10 I need a formula that takes that array and gives me which values equal to the number 7 (5+2)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

A formula in excel that will look up values that sum up to a specific number without using solver. For example: column A has these values: 2,6,8,5,9,10. I need a formula that takes this array and...

A formula in excel that will look up values that sum up to a specific number without using solver. For example: column A has these values: 2,6,8,5,9,10. I need a formula that takes that array and...

A formula in excel that will look up values that sum up to aspecific number without using solver.For example: column A has these values: 2,6,8,5,9,10. I need aformula that takes that array and give 2...

Karane Enterprises, a calendar-year manufacturer based in College Station, Texas, began business in 2019. In the process of setting up the business, Karane has acquired various types of assets. Below...

Having difficulty with this lab :/ any kind of help would be useful and very much appreciated! Learning Objectives: Deeper understanding about the costs associated with an Ordering policy (i.e. an...

Task 1 Print Computing the Limit of a Difference Quotient In this activity, you will compute the limit of a difference quotient to determine the rate of change of a function at different points along...

My teacher gave this for homeowrk and im really confused what to do he didnt really explain it that well. Using a Spreadsheet to Analyze Annuities Name 1. Creating an investment template Open a new...

please comment so I can share you the link to excel file EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.4 1.4 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap...

EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.4 1.4 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in...

Write a short paper describing your current (or most recent) job and the compensation system in place at your current (or most recent) place of employment. Dont use the name of a company, just...

A loaded train freight car (10 metric tons) rolls at 2 m/s East towards another freight car. The second freight car is traveling West at 3 m/s. Its mass is 15,000 kg. Upon collision the two cars lock...

True or false: Can a Certified Mental Performance Consultants accept alternative forms of payment? If so , what conditions need to be met?

Both Bond Sam and Bond Dave have 7.3 percent coupons, make semiannual payments, and are priced at par value (which is $1,000). Bond Sam has 3 years to maturity, whereas Bond Dave has 20 years to...

4. If you were Paul, what problems would you anticipate at this point?

Create hy being extemfllly open: How can I [aim find change?

3. What might be the response of the attorneys to this change?