# Lookup from a different column to return sum value if criteria is met.

1. ## Lookup from a different column to return sum value if criteria is met.

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.

pang.

try one.xlsx

2. ## Re: Lookup from a different column to return sum value if criteria is met.

Bit more detail where on the sheet your wanting the information to show up?

nevermind, looked at all the sheet now :P

3. ## Re: Lookup from a different column to return sum value if criteria is met.

hi,

on the summary side. in the grey coloured box. data is entered on the orange coloured cells.

4. ## Re: Lookup from a different column to return sum value if criteria is met.

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)

5. ## Re: Lookup from a different column to return sum value if criteria is met.

thanks Fdibbins.

that formula worked great.

6. ## Re: Lookup from a different column to return sum value if criteria is met.

Happy to help and thanks for the feedback

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1