Forum Discussion
excel functions
Many years ago I had a function on excel that would allow me to make changes on a spreadsheet if I knew a sum (dollar amount) and if I were to select a certain column lets say quantities, the excel spreadsheet would increase or decrease the quantities and reflect the sum that I was trying to achieve. Could someone direct me to the equation or means so I can utilize this function?
I put your question to the Bing chatbot. Here is its answer:
I'm sorry, but I couldn't find any specific information about an Excel function that would allow you to make changes to a spreadsheet based on a sum and a selected column of quantities. However, there are several functions in Excel that might be able to help you achieve your goal, such as the `SUMIF` and `SUMIFS` functions ¹². These functions allow you to sum values based on one or multiple conditions. You may want to explore these functions further to see if they can help you achieve your desired result.
Is there anything else I can help you with?
Quelle: Unterhaltung mit Bing, 20.6.2023(1) Sum values based on multiple conditions - Microsoft Support. https://support.microsoft.com/en-us/office/sum-values-based-on-multiple-conditions-e610ae0f-4d27-480c-9119-eb644f1e847e Zugegriffen 20.6.2023.
(2) SUMIF function - Microsoft Support. https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b Zugegriffen 20.6.2023.
(3) REDUCE function - Microsoft Support. https://support.microsoft.com/en-us/office/reduce-function-42e39910-b345-45f3-84b8-0642b568b7cb Zugegriffen 20.6.2023.
