A ideia em uma frase Five functions solve most spreadsheets: sum, average, conditional, lookup and count. SUM adds a range AVERAGE average of a range IF returns a value if the condition is true VLOOKUP looks up a value in a table COUNTIF counts cells matching a criterion Use $ (e.g. $A$1) to lock the reference when copying the formula. Tip Fonte: Microsoft Excel / Google Sheets documentation.