What Formula
Im trying to create an efficient stock count worksheet
I have a long list of productcodes running down column F with a quantity relating to the productcode in column G
The same codes can appear frequently down column F but with a different quantity in column G everytime
I need a function that searchs column F for a productcode(could appear 15 times) and returns the sum of all the quantities in column G that are related to the productcode i searched for
I hope thats clear
Any help would be greatly appreciated!!
Phil
Last edited by BodyHaven; 07-03-2008 at 12:48 PM.
Have a look at the SUMIF function in Excel help...
e.g. =Sumif(A:A,"product_code",B:B) would sum all values in column B where column A contains "product_code"
BTW: Please read our forum rules and update your title accordingly.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
This is actually the formula i have been using up till nowOriginally Posted by NBVC
The problem i am having is, i have to type the productcode into the criteria field of the equation. It wont return a correct value if i use a reference to the productcode (ie. =R4)
=SUMIF(A:A, R4, B:B)
Please read the Forum Rules about thread titles, and then amend your thread title as NBVC requested.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks