View Single Post
  #1   Report Post  
JP SIngh
 
Posts: n/a
Default Sumif on two criteria

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