SUMIFS and COUNTIFS

SUMIFS and COUNTIFS This quick video explains the SUMIFS and COUNTIFS Function in Excel. The SUMIFS and COUNTIFS functions allow us to add or count a range using multiple criteria – this is the function to use where multiple tests are required where usually an AND or...

The Choose Function, the Alternative to the IF or Vlookup

The Choose Function, the Alternative to the IF or Vlookup The Choose function is categorized in the latest versions of Excel as a Lookup and Reference formula, it returns a value from a set list of arguments based on a given position. The function looks as follows:...