LinkBack URL
About LinkBacks
I need sum of say Column 'E', 'G', 'I', 'K' etc. if A2 of Sheet2 matches with Column 'C' and B2 of Sheet2 matches with Column 'D', 'F', 'H', 'J' etc.
A sample file is attached for your understanding and consideration.
Thanks in advance.
Gajaburu
I need sum of say Column 'E', 'G', 'I', 'K' etc. if A2 of Sheet2 matches with Column 'C' and B2 of Sheet2 matches with Column 'D', 'F', 'H', 'J' etc.
A sample file is attached for your understanding and consideration.
Thanks in advance.
Gajaburu
E2 confirm COntrol+Shift=Enter:
=SUM(IF(LEFT('Challan Details'!$J$1:$AE$1,4)="Item",IF('Challan Details'!$J$2:$AD$7=$D2,'Challan Details'!$K$2:$AF$7)))
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks