PromptBase
Upgrade
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

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!
🤖 GPT

Excel Formula Assistant

Add to Cart
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
GPT-3.5-TURBO
Tested icon
Guide icon
Free credits icon
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
Added over 1 month ago
Report
Browse Marketplace