Excel Tips: Calculation & Formulas > Math Functions

ABS Function

How to calculate the absolute difference between two values/times in Excel?

How to get the opposite of a ABS value in Excel?

SQRT Function

How to quickly calculate the square root of a value in Excel?

SUMIF Function

How to sumif adjacent cell is equal, blank or containing text in Excel?

How to sumif based on partial match in Excel?

How to sumif cell values between two given dates in Google sheets?

How to sumif cells begin with specific number or text in Excel?

How to sumif cells if contains part of text string in Goolge sheets?

How to sumif cells not equal to a specific value in Excel?

How to sumif date is less/greater than today in Excel?

How to sumif with 3d reference to sum across tabs based on criteria in Excel?

How to sumif with multiple criteria in one column?

How to sumif with numbers stored as text in Excel?

How to sumif with one or more criteria in Excel?

SUMPRODUCT Function

How to multiply two columns and then sum in Excel?

How to quickly calculate the square root of a value in Excel?