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
|