K
K
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
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