Posts

Showing posts from November, 2016

Excel COUNTIFS Function

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) ref:https://exceljet.net/excel-functions/excel-countifs-function
Post a Comment
Read more

Excel COUNTIFS Function

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) ref:https://exceljet.net/excel-functions/excel-countifs-function
Post a Comment
Read more

[Excel][INDEX/MATCH]How to use INDEX MATCH function in Excel

Image
=INDEX ( column to return a value from , (MATCH ( lookup value ,  column to lookup against , 0)) reference: https://www.ablebits.com/office-addins-blog/2014/08/13/excel-index-match-function-vlookup/
Post a Comment
Read more