Wow what a quick response - Col B reads 1 for jan 2 for feb etc & feeds from
a date col using =month() formula. Town is formatted as text month is
formatted as number. Just tried the formulars suggested & still get the
value error so Im ob missing something....
"Don Guillett" wrote:
First, Are your col B text reading "Jan", "Feb", etc or properly formatted
dates? NON array
=SUMproduct((A2:A10=€¯Town X€¯)*(month(B2:B10)=1)*C2:C10)
or
=SUMproduct((A2:A10=€¯Town X€¯)*(B2:B10=€¯Jan€¯)*C2:C10)
to do as an array formula you would use =sum(if(etc
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"K" wrote in message
...
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