excel

1. Problem Situation In real-world data handling, it is often necessary to apply filtering to a large data table based on specific criteria (e.g., specific period, particular department) and then calculate the sum of only the cells visible on the screen. If you use the standard SUM function (e.g., =SUM(A1:A10)), it includes the values from … Read more

[The Problem] Have you ever been stuck in this situation while working on a report? “I need the total sales, but I want to exclude all ‘Refunded’ items…” Usually, people calculate the grand total and then manually subtract the specific items using a calculator. If you have hundreds of rows, this is not only time-consuming … Read more