hi all,
need help for lookup formula from a column to give a summary of the person who made a sale at the specific price range.
attached a sample file for reference.
thanks for your help in advance.
pang.
try one.xlsx
hi all,
need help for lookup formula from a column to give a summary of the person who made a sale at the specific price range.
attached a sample file for reference.
thanks for your help in advance.
pang.
try one.xlsx
Bit more detail where on the sheet your wanting the information to show up?
nevermind, looked at all the sheet now :P
Last edited by AYData; 08-19-2013 at 12:23 AM. Reason: corrected myself
hi,
on the summary side. in the grey coloured box. data is entered on the orange coloured cells.
This will give you what you want for the 1st small table...
=SUMIFS($F$9:$F$60,$C$9:$C$60,$W9,$I$9:$I$60,MID(Z$7,SEARCH("$",Z$7,1)+1,5)*1)
and use this for the 2nd small table...
=SUMIFS($F$9:$F$60,$M$9:$M$60,$W9,$S$9:$S$60,MID(AF$7,SEARCH("$",AF$7,1)+1,5)*1)
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
thanks Fdibbins.
that formula worked great.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks