I wish to calculate the total pages based on 2 other criteria, the year and language column. For example, how could I calculate the total EN page numbers from 2022? or the total DE page numbers from 2023?

I have searched on the internet, and found interesting things about google sheet and excel functions: index, match, vlookup ...but i could not find example of what i could use, or maybe i'm just very new at this. Could anyone please help me?

CodePudding user response：

try:

=SUM(FILTER(H:H; G:G=2022; I:I="DE"))