Sum or call the Value by Matching Colum and Row condition
Hello all,
Here I am facing the problem in excel sheet. I attached the excel sheet plz find that.
My problem is, I want to sum all the value regarding particular person by matching the condition of row and column.
For example : - On the date of 16-Feb-2017 sum of all Plan and Actual value regarding to Tiwari.
Please help it will be highly appreciated.
Thanks in advance
Try
F17Formula:
Please Login or Register to view this content.
drag down.
P.s please unmerge both date and name cell and put name and date each cell.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hi, welcome to the forum
Try this, copied down...
=SUMPRODUCT(($A$2:$A$13=E17)*($B$2:$B$13=$D$17)*($C$1:$V$1=$C$17),($C$2:$V$13))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks you very much friend. You solve my problem.Originally Posted by shukla.ankur281190
Try
F17Formula:Please Login or Register to view this content.
drag down.
P.s please unmerge both date and name cell and put name and date each cell.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks