Sum values associated with date range and another criteria?

[Burty]

Dear one and all,

I'm up shit creek without a paddle at the moment. I have a tabl
similar to that below in Excel2000:

01/10/2004 £10 Bob
01/10/2004 £20 Bob
05/10/2004 £50 Claire
01/11/2004 £25 Bob

I want to sum the money associated with a particluar person for
particular month.

I can sum all values associated with a particular month e.g. Oct 200
by:
=SUMIF(A1:A4,"<="&DATE(2004,10,31),B1:B4)-SUMIF(A1:A4,"<"&DATE(2004,10,1),B1:B4)
, but I do not know how to add in the criteria for if it also belong
to a particular person.

My respect goes to the first person that can help.

Burt

 

[Alex Delamain]

The following will give Bob's money for month 10 (october) = £30
Change month and name as required for the rest.
Alternatively you might want to use a pivot table which will do all the
calculations together.

=SUMPRODUCT((MONTH(A1:A4)=10)*(C1:C4="bob")*(B1:B4))