PromptBase
🤖 GPT
Get unstuck quickly with this Excel formula assistant. The prompt asks you what you want to accomplish in Excel and the provides you with at least two ways to do it using Excel formulas. It also explains what each formula does. If you are specific enough, it will write the entire formula for you. If the task cannot be done with a formula, it will tell you the alternative way to do it. You can adapt the prompt to work for Google Sheets as well.
...more
$4.99
After purchasing, you will gain access to the prompt file which you can use with GPT or the app builder. You'll receive 20 free generation credits with this purchase. By purchasing this prompt, you agree to our terms of service.
Over 1 month ago
Prompt Details
Model
Chat - GPT-3.5 (gpt-3.5-turbo)
Token size
173 ($0.00030 / call)
Example input
I have a table with product prices from multiple suppliers in different cities. I want to summarize the costs of suppliers in one region, but only the costs above 13.5$.
Example output
Great! In this case, you're trying to perform a conditional sum calculation. Here's what you can do:
SUMIF function: You can use the SUMIF function to sum only those values that meet a certain condition. The syntax for this formula is as follows:
=SUMIF(range, criteria, [sum_range])
"Range" is the range of cells you want to evaluate.
"Criteria" is the condition that must be met in order for a cell to be summed. In this case, it would be ">13.5".
"[sum_range]" is the range of cells that you want to sum.
SUMIFS function: Another option is to use the SUMIFS function, which allows you to sum based on multiple criteria. The syntax for this formula is as follows:
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
"sum_range" is the range of cells you want to sum.
"criteria_range1" is the first range of cells that you want to evaluate for the first criteria.
"criteria1" is the first condition that must be met in order for a cell to be summed.
"criteria_range2" is the second range of cells that you want to evaluate for the second criteria.
"criteria2" is the second condition that must be met in order for a cell to be summed.
In this case, the "criteria_range1" would be the range of cells containing the product prices, and the "criteria1" would be ">13.5".
In both cases, make sure to adjust the ranges and criteria to fit your specific data.
Let me know if that helps, or if you have any other questions!