hello
I need a sumproduct or index match formula that will automatically search thru the listed criterias in my cell i.e. F6.
The raw data in in row 23 down and across.
the type of product is in E6, the first criteria is in F5, second criteria F4...
can someone pls help...ive been stuck on this for half a day :S
thank you.
any thoughts on this guys ? pls and thx u
hey guys
i tried this new formula on this updated sheet:
=SUMPRODUCT(--('Raw data'!$D:$D=PL!F$8),INDEX('Raw data'!$G$25:$BS$384,MATCH($F$6,'Raw data'!$G$22:$BS$22,0),MATCH(PL!$B9,'Raw data'!$G$23:$BS$23,0)))
but getting N/A as my result....can someone pls see the attached and let me know what the issue may be?
thx u
1st, forum rules suggest that you wait at least 24 hours before "bumping" your thread.
2nd, can you give a few samples of what you expect as an answer? the 2nd item you are looking for is 321, and there are a bunch of them, do you want them added?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello FDibbins
my apologies.
In terms of your questions, for example, in the "PL" sheet cell G9, I am asking the formula to
-filter by # in cell G9 = 893 (raw data sheet has company # listed in column D)
- then filter by quantity - row 23 has the quantity in cell G23 down (raw data sheet)
- then filter by year type - row 22 has the year listed "year 2013" (raw data sheet)
thus, for company 893, there should be 55,938 quantity sold for year 2013.
hope that makes sense?
I want the formula dynamic as i require the invoice, net sales etc. thank you in advance.
OK take a look at the attached. To simplify things, I added a helper row under the headings in the main table to combine the row 23 and 24. Also, you need to make sure that ALL headings match...for instance, you had "Invoiced Sales" in row 5, but "Invoiced Sales, FreeCur" in row 24. Also, check the headings in I4:K5, I dont think they exist in 24:25
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks