Excel Forum

Excel Magic Trick 730: SUMIF with Approximate Criteria

Download file: http://people.highline.edu/mgirvin/
Learn how to use the SUMIF function with Approximate Criteria to add when criteria has other content in the cell. For example get a match for Qty when the cell has Jan Qty.

Got a Question? Ask it Here in the Forum.