You can use SUMIF to calculate a sum based on a condition ... This is what the function looks like: =SUMIF(range, criterion, [sum_range]) How to use SUMIF with a simple number condition Even ...