Hi, I’m trying to use “SUMIF” to run calculations with data from a table to summarize the quantity of some data.
I want to select data from a Drop-down field and summarize the number quantity on the same row.
Have any solution?
Hello @Chatchai_Chaichoompo ,
Welcome to the Kintone Developer Forum & thank you for posting your question!
Few things to note:
- Kintone does not have a
SUMIFfunction built into the Calculation field - Instead, there is a
IFandSUMfunctions that can be used together
If you are just getting started, check out the following articles from Kintone Help:
- List of Operators and Functions
- SUM/CONTAINS Functions: Calculations in Tables
- IF Function: Changing the Value to Display Depending on the Condition
- CONTAINS Function: Calculation using Check Boxes and Multi-Choices
To better help you out, please provide more information regarding:
- Share your code
- Screenshot of your App settings
- Your desired outcome
- If you got an error message, please post screenshots