In this tutorial, you will learn how to use SUMIFS with multiple criteria in same column in Excel.
With the SUMIF function in Excel, we may sum cells based on multiple criteria in one column in addition to sum cells based on multiple criteria in other columns. In this post. I’ll discuss how to add values that meet multiple criteria in the same column.
Once ready, we’ll get started by utilizing real-world examples to show you how to use SUMIFS with multiple criteria in same column in Excel.
Table of Contents
SUMIFS with Multiple Criteria in Same Column in Excel
Before we begin we will need a group of data to use SUMIFS with multiple criteria in same column in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want to total the run time for both Sean and Mandy. To do so, we can simply insert the following formula =SUMIF(A1:A9,”Sean”,B2:B9) + SUMIF(A2:A9,”Mandy”,B2:B9).
Step 3
Once we are done, you will be able to use SUMIFS with multiple criteria in same column in Excel.
