Together with values in Google Sheets is easy enough to attain the use of the SUM characteristic. But what in the event you handiest desire so that you might per chance add numbers that meet sure criteria? The use of SUMIF in a Google Sheets components, you might per chance also add the genuine values you indulge in to bear.
SUMIF is a model of functions that can set you time from manual work. As a replacement of scouring your data and manually adding the numbers you have to, you might per chance also pop in a components with the SUMIF characteristic. The criteria you utilize in the components on the complete is a quantity or text. Plus you might per chance also add values in a outlandish cell range based on the factors in a single other. Right here’s the design it works.
Inform the SUMIF Feature in Google Sheets
The syntax for the characteristic is SUMIF(cell_range, criteria, sum_range) the keep the first two arguments are required. You can per chance also use the sum_range argument for adding cells in a selection as a change of the look up range. Let’s peek at some examples.
RELATED: Easy pointers on how to Get Records in Google Sheets with VLOOKUP
To delivery straightforward, we desire so that you might per chance add the values in the range B2 thru B12 if they are elevated than 450. You will use this components:
=SUMIF(B2:B12,">450")
The first part of the components in parentheses is the cell range we’re shopping for the values. The “>450” fragment looks to be like for values elevated than 450 in that range. The SUMIF characteristic then adds the values meeting those prerequisites.
You can per chance also use the elevated than, lower than, or equal to operator in your components. With a microscopic adjustment, this components adds the values if they’re elevated than or equal to 450:
=SUMIF(B2:B12,">=450")
Maybe the values you indulge in to need so that you might per chance add are based on criteria in a outlandish cell range. Right here’s in the event you would use the sum_range argument.
So to add the values in the cell range B2 thru B12 handiest if the worth in the range A2 thru A12 is Location A, you would use this components:
=SUMIF(A2:A12,"Location A",B2:B12)
For one other example the use of the elective argument, we desire so that you might per chance add the values in the range F2 thru F12 handiest if a save in B2 thru B12 is elevated than or equal to 500. Right here’s the components:
=SUMIF(B2:B12,">=500",F2:F12)
The next time you ought so that you might per chance add values in your sheet but desire to present sure you handiest encompass sure ones, are attempting the SUMIF characteristic in Google Sheets. Make certain that to look at out pointers on how to peek basic calcul