The SOMME.SI.ENS (SUMIFS) function adds the values of a range for the rows that meet several criteria at once. Its syntax puts the range to add first, then pairs of criteria range and criterion. The ranges must be the same size.
Example
=SOMME.SI.ENS(C2:C100;A2:A100;"Nord";B2:B100;">=2026")