I am trying to add a formula of Sumif with Index match to get the Sum of values which are in Different Coloum in Sheet.
Can anyone please help......
=INDEX(ORder!$R$2:$R$1299,MATCH(1,(Planning!B2=ORder!$G$2:$G$1299)*(Planning!E2=ORder!$V$2:$V$1299),0)+(SUMIF(ORder!$G$2:$G$1299,Planning!$B$2:$B$115,ORder!$R$2:$R$1299)))
what its not working
It might help if we could see what you're trying to achieve... Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Click on GO ADVANCED and use the paperclip icon to open the upload window.
The paperclip icon
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks