sum similar record in range in Excel

Q21. In Excel, how can I find the sum of records that meet a given condition in my raw data table?

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 excel sum similar record in range

 

You can find similar Excel Questions and Answer hereunder

1) How can I find the slab in which a given value fits?

2) How can I set FreezePanes in a certain range using VBA?

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

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

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

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

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

8) How can I add a Prefix to a set of numbers in a range?

9) Is there a way to easily shade alternate rows in a data range for improving readability?

10) How can I get an estimate of Standard Deviation of a sample dataset?

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

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

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

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

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