Alternative to SUMPRODUCT

Attach a workbook, not an image - it's really hard to tell what's going on from that picture, and I can't copy your formula (or even see the row / column headings) to see your references...

Originally Posted by elavarasi19

I need your help ,

I have a excel sheet
sheet 1

i want output in sheet 2

Kindly help me sir

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Originally Posted by elavarasi19

.....
Kindly help me sir

@ elavarasi19
Hi elavarasi19
Welcome to Excel Forum

You are posting incorrectly

You must start a new Thread here

http://www.excelforum.com/excel-programming-vba-macros/
or here:
http://www.excelforum.com/excel-general/
or here:
http://www.excelforum.com/excel-formulas-and-functions/
_............................................

Please take some time before posting to read the Forum Rules here
Please take some time to read the Rules and Posting Guidelines
http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/forums-rules/

Thanks

_..............................................

P.s.
_B) Please avoid using Images to show a spreadsheet Range.
Please
Either:
Post screenshots COPYABLE to a Spreadsheet: – See my signature below,
or here:
http://www.excelforum.com/excel-prog...ml#post4399581
Practice here:
http://www.excelforum.com/development-testing-forum/

OR:
Upload a Workbook: See here:
http://www.excelforum.com/the-water-...his-forum.html
http://www.excelforum.com/suggestion...ml#post4335120
OR:
There is also the file share site option such as this free thing:
https://app.box.com/signup/personal
(_ .Remember to select Share after uploading and give us the link they provide if you use that )
But Note: a lot of people can’t / won’t download a File from an external site. So this method is not preferred here
For security reasons and to increase your chances of a response, It is preferable to upload a File with no codes in it and post any codes in the Thread ( using Code Tags # )
Practice here:
http://www.excelforum.com/development-testing-forum/

And Finally
Please do not post anymore in my Thread
http://www.excelforum.com/showthread...t=#post4427939
http://www.excelforum.com/showthread...t=#post4427932





Alan

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.