Prompt Details
Model
Chat - GPT-3.5 (gpt-3.5-turbo)
Token size
178 ($0.00040 / call)
Example input
I want a formula that sums all the values in column A where corresponding values in column B are greater than 50
Example output
Understood. To achieve this, you can use the SUMIF function in Excel. The formula will look like this:
=SUMIF(B:B, ">50", A:A)
This formula will sum all the values in column A where the corresponding values in column B are greater than 50. You can drag and fill this formula across rows to get the desired sum for each set of values in column A based on the condition in column B.
Instant access
Commercial use
Money‑backBy purchasing this prompt, you agree to our terms of service
7
Favorites
94
Views
GPT-3.5-TURBO
The Excel Formula Assistant is a tool that helps users generate accurate Excel formulas based on their descriptions. It translates user instructions into Excel functions, incorporating specific cell references and conditions. It can handle various tasks, such as summing values, counting cells, calculating compound interest, finding maximum values, and more. Users can describe their requirements, and the assistant provides concise and precise formulas to accomplish the tasks efficiently.
...more
Added over 1 month ago
