The Sumproduct is the formula function used in excel. This very useful formula function in excel, the uses are
1- To get multiplication sum of a series of data
eg:- If the 1st rows have product item quantity and second rows have product item rate. for getting the sum of the all product item you can use the following formula
ie =sumproduct(1st rows,2nd rows)
2- To get the answer as per the criteria
eg:- if you want to get the sum total of quantity of product, which are placed in rows. but there were another product name also mixed with this. you can get a perticular product calculation by using following formula
ie =sumproduct(1st rows,2nd rows*(criteria rows=criteria))
two more condition can also use by this
CAclubindia
