Frequently Asked Question

Excel add up cells based on what the cell contains
Last Updated 4 years ago

= SumIF(Range, Criteria, Sum_Range)

This equation will scan a specified range and check the value to see if it meets a requirement then it will add the value in specified range if the requirement is met.

this will sum cells a2:a5 if the value of a2:a5 is less than 340

Less than sign Greater than sign >
Not equal to
Greater than or equal to >=
less than or equal toEqual to =

Please Wait!

Please wait... it will take a second!