Sum similar record in range in Excel

For example, I want to find the sales contribution in each region from my raw data table.

To do it in Excel, here is the answer:

a) Enter the formula =SUMIF($O5:$O14,$O15, P5:P14) where O5:O14 has data that corresponds to the criteria, O15 represents the criteria and P5:P15 has sales data that need to be totalled if criteria is met.

excel sum similar record in range

b) Copy the formula as needed for the data pertaining to other regions and quarters.

excel sum similar record in range


You can find similar Excel Questions and Answer hereunder

1) How can I fill a range of cells with incremental times?

2) How can I clear all formats (formats alone not data) from a range of cells?

3) How do I get the 2nd highest number in a range of numbers?

4) In a Table , how can I remove duplicate records?

5) How can I find the count of records that meet a given condition in my raw data table?

6) How can I quickly remove all blank cells in a data range?

7) How can I set up a dynamic named range that expands automatically when new items are added to the list?

8) How do I find the median salary of employees with the same skillset in my Organization?

9) Is there a way I can average a range of numbers even if there is an error value in range?

10) How can I remove hyperlinks from a range of cells?


Here the previous and next chapter