Specifically, let's use it to sum units sold for a particular date in the sheet below. What makes this function even more flexible is that criteriarange and criteria don't have to be the same type of values or operators from set to set.īefore we take on an example, let's briefly review SUMIF(). Where sumrange is the contiguous set of values you're summing, criteriarangex represents the possible conditional values, and criteriax expresses the condition.
0 Comments
Leave a Reply. |