Need an excel formula to find which all cells in a given range sum to a specific amount
Budget: ₹600 – ₹1,500 INR
I need an Excel formula that can find which cells in a given range sum to a specific amount.
Requirements:
- The formula should exclude cells with a value of 0.
- The formula should consider both whole numbers and decimals.
- The preferred method of output for the results is to highlight the cells.
- The maximum number of cells that can sum to the specified amount is between 6 and 10.
Ideal Skills and Experience:
- Advanced knowledge of Excel formulas and functions.
- Experience with manipulating and analyzing data in Excel.
- Strong problem-solving skills.
Please note that the formula should be able to handle different ranges and specific amounts.
Requirements:
- The formula should exclude cells with a value of 0.
- The formula should consider both whole numbers and decimals.
- The preferred method of output for the results is to highlight the cells.
- The maximum number of cells that can sum to the specified amount is between 6 and 10.
Ideal Skills and Experience:
- Advanced knowledge of Excel formulas and functions.
- Experience with manipulating and analyzing data in Excel.
- Strong problem-solving skills.
Please note that the formula should be able to handle different ranges and specific amounts.