Table of Contents
The SUMIFS function in Excel is a useful tool for adding up values in a column that meet specific criteria. This function allows you to specify multiple criteria within the same column, making it a versatile and efficient way to perform complex calculations. By using the SUMIFS function, you can easily add up data that meets specific conditions, saving you time and effort in your data analysis. This function is especially useful for large datasets, as it allows you to quickly and accurately sum up values based on multiple criteria. Overall, the SUMIFS function is a valuable tool for manipulating and analyzing data in Excel.
Excel: Use SUMIFS with Multiple Criteria in Same Column
You can use the following syntax to use a SUMIFS function with multiple criteria in the same column in Excel:
=SUM(SUMIFS(B2:B13,A2:A13,{"Guard","Center"}))
This particular formula calculates the sum of the values in the range B2:B13 where the corresponding value in the range A2:A13 is either “Guard” or Center.”
The following example shows how to use this syntax in practice.
Example: Use SUMIFS with Multiple Criteria in Same Column
Suppose we have the following dataset in Excel that shows the number of points scored by various basketball players:
We can use the following formula to calculate the sum of points scored by all players who have a position of Guard or Center:
=SUM(SUMIFS(B2:B13,A2:A13,{"Guard","Center"}))The following screenshot shows how to use this formula in practice:
We can see that the players who have a position of Guard or Center scored a total of 108 points.
We can manually verify this is correct by taking the sum of each of the Guards and Centers:
Sum of points for Guards and Centers: 12 + 8 + 8 + 9 + 20 + 22 + 29 = 108.
This matches the value that we calculated using the formula.
Cite this article
stats writer (2024). How can I use the SUMIFS function in Excel to add values in a column based on multiple criteria within the same column?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-sumifs-function-in-excel-to-add-values-in-a-column-based-on-multiple-criteria-within-the-same-column/
stats writer. "How can I use the SUMIFS function in Excel to add values in a column based on multiple criteria within the same column?”." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-sumifs-function-in-excel-to-add-values-in-a-column-based-on-multiple-criteria-within-the-same-column/.
stats writer. "How can I use the SUMIFS function in Excel to add values in a column based on multiple criteria within the same column?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-sumifs-function-in-excel-to-add-values-in-a-column-based-on-multiple-criteria-within-the-same-column/.
stats writer (2024) 'How can I use the SUMIFS function in Excel to add values in a column based on multiple criteria within the same column?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-sumifs-function-in-excel-to-add-values-in-a-column-based-on-multiple-criteria-within-the-same-column/.
[1] stats writer, "How can I use the SUMIFS function in Excel to add values in a column based on multiple criteria within the same column?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the SUMIFS function in Excel to add values in a column based on multiple criteria within the same column?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.