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.
=SUMIF(A2:A5,"
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 =
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.
=SUMIF(A2:A5,"
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 =