LinkBack URL
About LinkBacks
Solved!!!!
Solved!!!!
Last edited by Hessing; 10-29-2013 at 06:27 AM. Reason: SOLVED
if u want to count the material number in ur sheet . just use the countif formula.
=countif(range,criteria)
hi Hessing. it's good if you can type out the desired answers you want to see next time. helps us be more confident we're on the right track. maybe:
=SUMIF(A2:A12,"0123",G2:G12)
that totals column G when column A is 0123.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Or you can try this.......
=SUMPRODUCT(--($A$2:$A$12=A2),$G$2:$G$12)
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks