LinkBack URL
About LinkBacks
Ref. attached file Quesion.xlsx
Column E and F should bring total of columns C and D respectively of each serial number (column A - serial number). How to do this, pls help.
Ref. attached file Quesion.xlsx
Column E and F should bring total of columns C and D respectively of each serial number (column A - serial number). How to do this, pls help.
Last edited by jilaba; 02-27-2017 at 09:39 AM.
Ask me how to hate XL.
The workbook is protected!!!!!!
Sorry, i forgot. I reuploaded it without protection. Thanks.Originally Posted by davesexcel
Formula:
Please Login or Register to view this content.
Ya thanks. I attached the file after applying formula. It brings the value of each cell. I need the output such as in columns G, H.Formula:Please Login or Register to view this content.
Try this in E2:
=IF(COUNTIF($A$2:$A2,$A2)=1,SUMIF($A:$A,$A2,C:C),"")
Copy across and down.
[QUOTE=Phuocam;..........[/QUOTE]
thanks a lot. it did fine. i was trying to do this with lookup and failed. great work by you.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks