Sumif on two criteria

[JP SIngh]

Hi All

I have a three column worksheet

Date Type Amount

01/01/2005 NEIL SCHNEIDER HOUR
02/01/2005 JAMES (MEMBER) HALF DAY
03/01/2005 SHANDON PARK ONE DAY
04/01/2005 SHANDON PARK TWO DAY
05/01/2005 EDWARD BOX PERSONAL
06/01/2005 JUNE BENSON SHORT


I want to be able to do a formula so I can sum all the amounts for say
January and "HOUR".

Any help is appreciated.

Regards

 

[Don Guillett]

try
=sumproduct((month(a2:a22)=1)*(d2:d22="hour"))
to count all instances of hour in january
you do NOT give an amount column but this will sum col e that meets the
criteria.
=sumproduct((month(a2:a22)=1)*(d2:d22="hour")*e2:e22)

 

[JP SIngh]

I used that formula but it gives me "3" which is counting the enteries.

01/01/2005 NEIL SCHNEIDER HOUR £50 CASH
02/01/2005 JAMES (MEMBER) HALF DAY £75 CASH
03/01/2005 SHANDON PARK ONE DAY £140 CHEQUE
04/01/2005 SHANDON PARK TWO DAY £250 CC
05/01/2005 EDWARD BOX PERSONAL £275 CC
06/01/2005 JUNE BENSON SHORT £50 CASH


For example in the above example I would like to sum all the amounts for
cash in january

any help

 

[Don Guillett]

RE-Read my post and adapt to suit your needs. If that doesn't work, read it
again. If that doesn't work, copy your formula here for help.

 

[JP SIngh]

it works indeed.

thanks a lot.

RE-Read my post and adapt to suit your needs. If that doesn't work, read it
again. If that doesn't work, copy your formula here for help.

 

[Don Guillett]

glad you thought it out