SUMIF with VLOOKUP

[unknownymous]

Hi Gurus,

Any thoughts on what would be the right sumif lookup formula for below scenario?

Sheet 1 - I have a long list of Data. Simple example below:

Name	Change
Sam	250
Mike	300
Sam	-500
Mike	-150
Sam	-50
Mike	-25

Sheet 2 - I'm having a hard time doing it in pivot so just wondering if I could just create a formula in B2. Below is the final output I want to see.

Table 1: Will sum up all the Positive Numbers Only (in Sheet 1) with name as reference

Name	Change (Positive Numbers Only)
Sam	250
Mike	300

Table 2: Will sum all the Negative Numbers Only (in Sheet 1) with name as reference

Name	Change (Negative Numbers Only)
Sam	-550
Mike	-175

Any ideas or thoughts are appreciated.

 

[Fluff]

How about

=SUMIFS(Sheet1!B2:B200,Sheet1!A2:A200,A2,Sheet1!B2:B200,">0")

 

[unknownymous]

How about

=SUMIFS(Sheet1!B2:B200,Sheet1!A2:A200,A2,Sheet1!B2:B200,">0")

Cool beans! Thank you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.