In Excel, my data is in columns [A: date, B: region, C: sales] with headers in row 1, rows 2 to [500].
I need a formula that [task, e.g. sums sales for the region in F2 for the month in G2].
Give: the formula, a one-line explanation of each part, a version that works without dynamic arrays, and one common mistake to avoid.