One popular formula that is frequently used is the SUMIF / SUMIFS function. The purpose of this function is to add numbers only if a specific criteria is met. The input is as follows:
=SUMIF(range, criteria, sum_range)
The first number, "range," is the area your requirement will be. So if you want it to sum data that is in GL number 1020, and the GL numbers are in column C, your range will be column C, and your criteria will be 1020. Then let's say the amount is in column F - your sum range will then be column F.
Your formula would then read:
=SUMIF(C:C, 1020, F:F)
SUMIFS is backwards from SUMIF - the input is as follows:
=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)
The first number you input is the sum, then follow the criteria format shown above. So consider the same information, but you only want it to count retail region number 4. The retail region number is in column A. Your formula would then read:
=SUMIFS(F:F, C:C, 1020, A:A, 4)
Note: the order does not matter.
Please email me if you would like a sample workbook!
info@excelandvba.com
No comments:
Post a Comment