Excel doesn't have a direct way to add only visible cells, but you can achieve this using a combination of techniques:

Method 1: Subtotal Function (Works with Filters)

1. Select the range: Choose the cell range containing your data, including potentially hidden rows.
2. Insert Subtotal formula: In an empty cell below your data, enter the formula `=SUBTOTAL(9,A1:A10)` (replace A1:A10 with your actual data range).
- The `9` within the SUBTOTAL function specifies to include all visible cells when calculating the sum.

Method 2: Advanced Filter (For Complex Scenarios)

1. Copy visible data:
- Go to the "Home" tab.
- Click "Find & Select" and choose "Go To Special."
- Select "Visible cells only" and click "OK."
- Copy the visible cells (Ctrl+C).
2. Paste to new location: Paste the copied visible data (Ctrl+V) into a new location on your sheet.

Method 3: Tables (Limited Functionality)

1. Convert data to table: Select your data range and press Ctrl+T to convert it into an Excel table.
2. Apply filter: Use the filter arrows on the table headers to filter your data.
3. Copy and paste (Limited to Excel Desktop): You can directly copy and paste the visible data within the filtered table (this functionality might not be available in Excel web).

Choosing the Right Method:

- Subtotal: Use this for simple addition of visible cells when using filters.
- Advanced Filter: This method offers more flexibility for complex scenarios where you need to copy and manipulate visible data.
- Tables: Tables are a good option for quick filtering and basic copy-paste of visible data (especially in Excel Desktop).

Remember, these methods consider hidden rows/columns when performing calculations. They ensure the formulas or copied data only reflect the visible information within your chosen range.