You can add, subtract, multiply and divide in Microsoft Excel using basic formulas. Also, the SUM function for adding up a range of cells or "&" to join text from different cells can be very useful too in basic Microsoft Excel formulas.
Tag: Formula / Function
Match two lists
Use COUNTIF to match two lists.
Add a column
“Add a column” might mean either insert a new column or just calculate its total.
sum of multiple sheets
I identify three ways to get a sum of multiple sheets in Microsoft Excel.
Multiply two columns and sum
I outline two of the ways to multiply two columns and sum in Microsoft Excel.
Find duplicate rows
To find duplicate rows, first join up the cells on each row and then deploy the COUNTIF function. If count is greater than 1, then a particular row is a duplicate row.
Microsoft Excel average formula
To get an average of a range of numbers, either do a Microsoft Excel average formula or better still, use the Microsoft Excel AVERAGE function.
Lookup multiple values
Hello everyone! Did you know……If you want to lookup multiple values then use INDEX MATCH, "&" and an array formula.
Match Index special formula
For MATCH INDEX special formula use MATCH to look up and get position number which is then used within INDEX to return the corresponding value from the data range.
Extract text from a cell
Use the Microsoft Excel functions LEFT, RIGHT or MID to extract text from a cell.