Using wildcard in SUMIF

[bibbyd01]

Hi

I'm trying to use the wildcard to lookup any year in a column within the sumif function. I've used this millions of times but it's suddenly stopped working.

I have two checkboxes to select years 2009, 2010, and a formula cell to provide 2009, 2010 * (if both are selected) and "" if nothing is selected.

The sumif formula uses this cell to lookup against, but it's suddently stopped working. Is there an option in excel I might have ticked to prevent it from working? When either 2009 or 2010 are selected it works, so I know it's something to do with the wildcard. I've used this formula on other sheets and I've checked it and it still works fine.

My sumif formula is below. AG2 is the cell with either 2009, 2010 or *

=SUMIF('inv days 2010'!P:P,Summary!AG2,'inv days 2010'!J:J)

 

[Richard Schollar]

WIldcards can only be used in SUMIF with non-numeric data so if the column containg the years is numeric, the * won't work. You'd need something like ">=2009" instead.

 

[bibbyd01]

Brilliant, thanks!