Using sumifs

[CMS5504]

I am running excel 2010 on windows 7

If I create a table from scratch in a workbook I am able to use the sumifs function using ">="& a named range that contains the criteria
For example
Table name = tblTest
Column A = xYear
Column B = xAmt
I defined a range name as SelYear (a single cell)
The formula =sumifs(tbltest[xamt],tbltest[xyear],">="&SelYear)

This works just fine

However, when my table has been created by using a data connection to an access query it no longer works - just using the "=" sign works but it doesn't appear to be recognizing the ">="

Thanks

[NBVC]

You are sure you have Automatic formula calculations on? (Formulas Tab >> Calculations >> Automatic).

If so, does it work like this? =sumif(tbltest[xyear],">="&SelYear,tbltest[xamt]) ?

[CMS5504]

Thanks
Auto calculation is on
In Options>Formula the Use Table Names in Formulas is set to true
Your suggestion returned zero
I need to use sumifs because I will be using multiple critera - for example to pick up a data range I use =sumifs(tbltest[xamt],tbltest[xyear],">="&SelYear,tbltest[xyear],"<="&SelLastYear) where SelLastYear is another named range
Because it works on a table created from scratch but not I linked table I tried converting the linked table to a normal range and then converted it back to a table with no luck
The source of the table is a trusted source

Thanks

[NBVC]

I don't have Excel 2010 here, and I don't have access to your database to test.. so I am not sure if it is an XL2010 thing or not.

If you want, you can attach your workbook (if not confidential) and I can see how it works in XL2007.

[CMS5504]

The data was rather private so I build a test workbook
The names are a little different from my posts
The downloaded data is from an access 2010 query and is in sheet DownloadedData
I included a Pivot table just to show what the results should be
My named ranges and two examples of the problem are in the sheet Test
Thanks again

[NBVC]

It seems the problem is the PeriodYear column in tblTest. It seems Excel sees these as Text strings rather than numbers. If you select the column and go to DATA tab, then select Text to columns and just click Finish, you will see the numbers change to the Accounting format you have defined for the cells. Just change the format to General to get it to look like years... and now the formula should work.

[CMS5504]

WOW!
Thank you so much