Question about using a SUMIF statement with two sets of criteria

[phaley]

I am working in a workbook with multiple worksheets. On sheet1 I have a blank cell next to a person's name. On sheet2 I have 3 columns which are relevant to the amount I am trying to obtain.

Sheet2 has columns called "Account Owner", "Stage", and "MRR". Account Owner and Stage are text, and MRR is currency.

I'd like to perform a SUMIF that looks in the "Account Owner" column of sheet2 and match it with the name of the person on sheet1, but also looks in the "Stage" column for a value "Closed Won". If those two are true, then it would sum values from the "MRR" column in sheet2.

An example of this formula, which doesn't work is

=SUMIF('Sheet2!'Q:Q, [Condition1, Condition2], 'Sheet2!'E:E)

I tried using the AND() function within the SUMIF() statement, but it didn't work. Any ideas? Thanks to anyone that replies!

[VBA Noob]

Try sumproduct.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

VBA Noob