# Using SUM & CHOOSE Functions To Calculate Total Sales

Welcome to Excel Jet Consult blog post. In this post we want to learn how to use the rarely known lookup family function – CHOOSE. We will wrap the CHOOSE formula inside sum function. CHOOSE Function chooses a value to perform from a list of values based on index number CHOOSE Syntax                =CHOOSE(index_num, value1, [values2], …) In the caption below, […]

Continue reading

# How to Enable Nigerian Naira Currency Symbol

Nigerian Naira currency symbol by default is not available to format numeric values. However, Excel makes it easy to permanently enable the local currency symbol. To insert Nigeria Naira currency symbol: In the Symbols group of the Insert tag, click on Symbol In the Symbols tab of Symbol dialogue box, select (normal text) from the Font dropdown Select Currency Symbols from […]

Continue reading

# Understanding Absolute Cell Reference

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn about Absolute Cell Reference. An Absolute Cell Reference is a cell reference that contains dollar signs (\$) before column letter and row number (i.e. \$A\$1). The dollar signs ensure that cell \$A\$1 is fixed when formula is copied down or across using the fill handle. To apply […]

Continue reading

# VLOOKUP Approximate Match

Welcome to Excel Jet Consult blog post. In this short video tutorial, we will to learn how to use the VLOOKUP function approximate match. Enjoy

Continue reading

# Dynamic Advanced Conditional Formatting With Data Validation

Welcome to Excel Jet Consult blog post. In this short video tutorial, we will learn how to dynamically apply conditional formatting to our  data with List Data Validation drop-down. Enjoy the video

Continue reading

# Array Formula: SUM Contiguous & Non-Contiguous Values With VLOOKUP

Welcome to Excel Jet Consult. In this video tutorial, we will learn how to sum contiguous and non_contiguous values using VLOOKUP & SUM functions with array formula. Enjoy the video

Continue reading