Excel sumproduct using

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

Replies (5)

if you want to know any more about this, you can make query to me

Can u give brief details with example in excel sheet, it will be better for understand anybody.

Thanx+Regards

 

 

pls find the attachment

Dear Sir,

Pl give solution to this;

I am having Dates data which is in serially, when I using subtotal function it is coming date wise, but I want month wise, pl advise how to change my dates data into month wise, because it is huge data.

pls find the attchement

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details