Sumif using 2 criteria

[Pulzzed]

Using Excel 2010, how can we use Sumif using 2 criteria's? From Sheet 1, I need the sum of column E if Column A = John Doe and if a date has been entered into column G.

Currently we get the sum of column E (which is the invoiced amount) by using the following formula:
=SUMIF(sheet1!$A$3:$A$2100,"John Doe",Sheet1!$E$3:$E$2100)

 

[jfish1288]

=SUMPRODUCT((sheet1!$A$3:$A$2100="John Doe")*(sheet1!$G$3:$G$2100<>""),Sheet1!$E$3:$E$2100)

 

[wigi]

Or just using the SUMIFS function.

 

[Pulzzed]

Thanks jfish1288 it worked.