LinkBack URL
About LinkBacks
Hello. Can someone help me with this one? I'm still crossed-eyed trying to do it with IF functions. Thanks.
Hello. Can someone help me with this one? I'm still crossed-eyed trying to do it with IF functions. Thanks.
Last edited by MileWide; 11-02-2014 at 04:52 PM. Reason: adding excel spreadsheet
A spreadsheet would be better than an image
I cant see the image anyway
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Last edited by etaf; 11-02-2014 at 04:37 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hello,
Try in C4, then copy down.
=IF(COUNTIF(A$4:A4,A4)=1,SUMIF(A$4:A$14,A4,B$4:B$14),"")
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Wow, that was a fast reply. Your formula worked partially. However, if I change one of the duplicate part numbers, the total sum should be reduced but it stays at the same value. For example, if I changed cell A28 from "154-1001-00" to "154-1111-00", the value of C26 should be 150 but it is still at 550.
Ooops. Scratch my previous reply. I think it works! I'll double-check. Please standby.
Yup, works like a charm. You're awesome! Thanks!! I can see straight again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks