SUMPRODUCT Formula in Microsoft excel

 

SUMPRODUCT

Check below example and try to use in excel in real time for better understanding

Blue text start with "=" is the formula we used

SUMPRODUCT FORMULA

What Does It Do ?

This function uses at least two columns of values.
The values in the first column are multiplied with the corresponding value in the second column.
The total of all the values is the result of the calculation.

Syntax

=SUMPRODUCT(Range1, Range, Range3 through to Range30)

Formatting

No special formatting is needed.

 Example

The following table was used by a drinks merchant to keep track of stock.
The merchant needed to know the total purchase value of the stock, and the potential
value of the stock when it is sold, taking into account the markup percentage.

The =SUMPRODUCT() function is used to multiply the Cases In Stock with the Case Price to calculate what the merchant spent in buying the stock.

The =SUMPRODUCT() function is used to multiply the Cases In Stock with the Bottles In Case and the Bottle Setting Price, to calculate the potential value of the stock if it is all sold.



BACK TO HOME PAGE





If You Want free Stuffs or Products check our  

For More Offers SUBSCRIBE US  


https://excelknowlegde.blogspot.com

To Support US 


Comments

Post a Comment

Popular posts from this blog

FREE MICROSOFT EXCEL TUTORIAL / Learn free online Microsoft excel

Image
Introduction to Microsoft Excel What is Microsoft Excel? Microsoft Excel is a spreadsheet program used to analyze data and record number and text. In Microsoft Excel we can use many features like calculations, pivot tables, graphs, automation by macros etc. in Excel columns and rows makes a table. Columns are align it right to left with A,B,C names, and  rows are align in Up to Down in numbers. where column and row meet together is called cell. The cell represent the column and the number together. Where you can get Microsoft Excel? There are number of ways in which you can get Microsoft Excel. You can buy it from a cybercafé or computer shop . Microsoft Excel is part of the Microsoft Office. or you can download it from the Microsoft website and have to purchase it before use. In this Microsoft Excel tutorial, we are going to cover the following topics about MS Excel. How to Open Microsoft Excel? Understanding the Ribbon Understanding the worksheet Customization Microsoft Exce...
Read more

Large Formula in Microsoft excel

Image
LARGE Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used LARGE FORMULA What Does It Do ? This function examines a list of values and picks the value at a user specified position in the list. Syntax =LARGE(ListOfNumbersToExamine,PositionToPickFrom) Formatting No special formatting is needed.   Example The following table was used to calculate the top 3 sales figures between Jan, Feb and Mar. Note Another way to find the Highest and Lowest values would have been to use the =MAX() and =MIN() functions.
Read more

UPPER Formula in Microsoft excel

Image
UPPER Check below example and try to use in excel in real time for better understanding Blue text start with "=" is the formula we used   What Does It Do ? This function converts all characters in a piece of text to upper case. Syntax = UPPER(TextToConvert) Formatting No special formatting is needed. BACK TO HOME PAGE If You Want free Stuffs or Products check our   For More Offers  SUBSCRIBE US    https://excelknowlegde.blogspot.com To Support US  Donate Now
Read more