SUMIF

Try using mapflo for data analysis instead of Excel. Get Started for Free.

Summary

With the SUMIF function, you look up a value in a specified range and return the sum the values in the corresponding output range.

Syntax

=SUMIF(“look_up_range”,”value_to_look_up”,”output_range”)

In the example below, the formula in cell E2 is =SUMIF(A2:A7,”Shorts”,C2:C7) and returns the value 39 as the Qty associated with “Shorts” in the range C2:C7 is 24+15 = 39.

Notes:

• SUMIF is not case sensitive.
• SUMIF can reference:
  • a number: =SUMIF(C2:C7,13,C2:C7) returns 13
  • a string: =SUMIF(A2:A7,”Shorts”,C2:C7) returns 39
  • a cell reference: =SUMIF(A2:A7,A3,C2:C7) matches to Sandals and returns 27
  • a math operator: =SUMIF(C2:C7,”>13″,C2:C7) returns 31
  • multiple wild characters: =SUMIF(A2:A7,”S*”,C2:C7) matches to Sandals and Shorts and returns 66 [where * denotes zero, one or multiple characters]
  • single wild characters: =SUMIF(A2:A7,”*sh?rts”,C2:C7) matches to T-shirts and Shorts and returns 58 [where ? denotes a single character]

Using mapflo with SUMIF

If you like Excel, then you’ll love mapflo. mapflo puts data through a flow. The Rank & Partition Node makes it easy to SUMIF, RANK, COUNTIF, AVG, MINIMUM or MAXIMUM:

No copying down formulas; no worrying about a change in dataset size.

Get started with mapflo for free.