Formula SUMIFrange criteria sum_range The formula uses the following arguments. Lets say you are trying to keep track of your average monthly. Type an equals sign the SUM function and the numbers you are adding surrounded by parenthesis.
Instead of using the WorksheetFunctionSUM you can use VBA to apply a Sum Function to a cell using the Formula or FormulaR1C1 methods.
To get this array-criteria approach to work you have to use one more little trick - enclose your SUMIF formula in a SUM function like this. Type out the first cell reference then a. It reduces the time when we are working with a large amount of data and need to calculate the sum of values of similar nature data. SUMIF is one of the functions which is very much useful to find the totals of similar values.