Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.

Match Function

Match Function The Match Function searches for a specified value and returns relative position of that value. It’s easier once you look at the example. Syntax =MATCH(lookup_value, lookup_array, …

Match Function Read More »


The countifs Function is used when you want to count data with multiple criteria. =COUNTIFS (range1, criteria1, [range2], [criteria2], …) *It is vital to add the parenthesis surrounding …

COUNTIFS Function Read More »

PMT Function

The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate. This formula will not work with a flexible …

PMT Function Read More »

Scroll to Top