Frequently Asked Question
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 =