View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
K K is offline
external usenet poster
 
Posts: 108
Default Sumif with more than one criteria

OK, pls can someone help before my comp goes out of the window!!! I need to
sum up a value if my cells meet 2 Criteria - I thought I had it using an Aray
but juet got the Value error message. Anyways I have 3 col's as below

Town month & Days - I need a formula to add up the days when the town &
Month Match I thought =SUM((A2:A10=€¯Town X€¯)*(B2:B10=€¯Jan€¯)*C2:C10) would
work giving me the total of Col c when Col A was Town X & B was the month of
Jan