This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Your filter should come first to remove any unnecessary rows. Then the order of the formula/summarize tools widely depends on the output but I would first summarize then use the formula tool, so the formula is applied to a smaller number of rows.