Summary of the expenses

hi forum,
i m facing some problem with the formula in my worksheet.i had a worksheet with the following data.
Date Month Sales Man Amount
01/4/11 Apr'11 A 1504
01/4/11 Apr'11 B 1425
01/5/11 May'11 A 1400
01/5/11 May'11 B 1409
01/6/11 Jun'11 A 1580
01/6/11 Jun'11 A 1250

I had built a table with the format:

DESIRED TABLE:##
Sales Man Apr'11 May'11 Jun'11
A 1504 1400 1580
B 1425 1409 1250

I know the same can be achieved using pivot table..but i want to do the same using a formula.For that i tried with Sumproduct. i used Name for the ranges for achieving the same.
For example:
Amt for the Amount Column in the main table/data
s_man for the salesman Column in the main table/data
Mon for the Month Column in the main table/data

FORMULA USED IN THE DESIRED TABLE
=SUMPRODUCT(s_man=$A$2)*(Mon=B1)*(amt)

i need sumproduct to show the total amount the salesman A had made in Apr month.similar with the other salesman B in all the months...
The result i m getting is :0 in all the cells in the desired table....

Please tell me where i m going wrong....

Here is one approach:

(Use SUMPRODUCT instead of SUMIFS for pre-2007 version)

I tried with SUMPRODUCT only zbor.kindly check once again.Error not traced..

I think i can achieve the same using NAMED RANGES in my formula even for SUMIFS also...

Works for me.. What doesn't work for you?

zbor,your sumifs work for me also.I m trying with the sumproduct & named ranges.kindly help.

Here is SUMPRODUCT version:

=SUMPRODUCT(Sheet1!$D$2:$D$1000, --(Sheet1!$C$2:$C$1000=Sheet2!$A2), --(Sheet1!$B$2:$B$1000=Sheet2!B$1))

You only need to name ranges as you want (i.e. instead of --(Sheet1!$C$2:$C$1000=Sheet2!$A2) --(NameThisRange=Sheet2!$A2))