Would have been nice of you to let everyone know these particulars up front,
from the outset.

Care to share as to what is *exactly* in Column C?

That #Value! error is probably coming from that column.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"K" wrote in message
...
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