Sumifs Not a number as a criteria

[largeselection]

Hello,

I'm using excel 2007, is it possible to do a sumifs and have one of the criteria be if the value in a column is not a number?

So I have a column which contains numbers and alpha strings, so I want to sum a different column wherever the first column doesn't have a number (so if it's blank or contains a text value).

Criteria something like <>#

 

[Richard Schollar]

Hi

You can do that using a SUMPRODUCT easily:

=SUMPRODUCT(1-ISNUMBER(YourColumn),ColumnYouWantToSum)

 

[mikerickson]

The criteria ">=:" will do a alphabetic comparison that all numbers fail.