CODEWITHSUNDEEP
excelexcel-formulams-office
Tehmina Batool
Tehmina Batool

Reputation: 47

Excel: How to not count a particular cell on condition?

I need to calculate a column having many cells but I want to not calculate particular cells on condition. For example:

Scenario: 

Sr No     Marks
 1           46
 2           33
 3           44
 4           32
 5           11
 6           99
 7           27
 8           98

I want to get the sum of marks but only those cells should be added whom marks are more than 50. What formula should use?

Upvotes: 0

Views: 99

Answers (1)

Tim Biegeleisen
Tim Biegeleisen

Reputation: 521904

We can use SUMIF here:

=SUMIF(B2:B9, ">50")

This assumes that your Marks column is in column B, and that the first data point is on the second row.

Edit:

If you want to take the average value of marks, where the mark is over 50, then we can also use COUNTIF:

=SUMIF(B2:B9, ">50") / COUNTIF(B2:B9, ">50")

Upvotes: 3

Related Questions