We are trying to SUM three (3) column and calculate its averaged but basing on the "Type" and "Year" that the line pertains to.
Included is an excel with what we are trying to do.
There are 3 columns with values (column Value1, Value2 and Value3).
We want to SUM and COUNT the columns "Value" based on the column "Type" and the column "Year".
Afterward get its average per value based on the year 2014.
In the excel we try to use SUMIF with COUNTA then tried to use SUMIFS, but can't seem to get the result we want.
The attached excel, in the columns N, O and P shows the value that the formula has to calculate (we placed it manually for comparison purposes).