Max's answer worked the best - Dons & daves worked but for some reason not
everytime - prob my formats....

Thank You for all your help & sorry if I confused anyone

"Don Guillett" wrote:

Post back with the final solution for the archives.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"K" wrote in message
...
Thank you all - I think I have now got it - will have a look in the
morning

"Max" wrote:

Try copying the formula directly from below, then paste directly into the
formula bar for D1, then press CTRL+SHIFT+ENTER to confirm the formula:
=SUM(IF((A2:A10="Town X")*(TEXT(B2:B10,"mmm")="Jan"),C2:C10))

It assumes you have real dates in col B
For better clarity, you could define it using both the month & year,
something like this: TEXT(B2:B10,"mmmyy")="Jan08"

P/s: The double quotes in your post look strange - like the left closing
quotes
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"K" wrote:
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