Operations in Excel
Excel
How to Sum Across Multiple Sheets in Excel
You can use the following basic syntax to sum values across multiple sheets in Excel:
=SUM(Sheet1!A1, Sheet2!B5, Sheet3!A12, ...)
The following example shows how to use...
Excel
How to Sum Filtered Rows in Excel (With Example)
The easiest way to take the sum of a filtered range in Excel is to use the following syntax:
SUBTOTAL(109, A1:A10)
Note that the value 109...
Excel
How to Delete Filtered Rows in Excel (With Example)
Often you may want to delete certain rows after filtering them in Excel.
Fortunately this is easy to do and the following example shows how...
Excel
How to AutoFill Dates in Excel (3 Examples)
Often you may want to autofill dates in Excel. Fortunately this is easy to do using the simple drag and fill feature built into...
Excel
How to Convert Time into Decimals in Excel (With Examples)
You can use the following formulas to convert a time into a decimal value in Excel:
1. Convert Time to Number of Hours: Multiply original...
Excel
How to Create a Lag Function in Excel (With Examples)
Often you may want to calculate lagged values in Excel. Fortunately this is easy to do use the OFFSET() function.
The following examples show how...
Excel
How to Match Two Columns and Return a Third in Excel
Often you may want to match the values in two columns and output a third column in Excel.
Fortunately this is easy to do using...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read