So you export the relevant data into Excel, where you use the SUMIF function [SUMIF (range ... Cells Z1 to Z3 contain 7, 8 and 9. A three-array formula would have this syntax: ...

1. The SUM function is probably the most basic function you need in Excel. You type in =SUM( and then select an array of values. This will result in the sum of the values in the array you've selected.

Use an Excel array function to create an AverageIf function Your email has been sent Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally. Excel has ...