Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there any way to get Excel to look at cells that contain data? I've been using >0 but this doesn't pick up the contents of the cell if if starts with letters. I'm trying to do a SUMIF command.

share|improve this question
To clarify... Is there numerical data also in these cells or are you trying to sum alphanumeric values? Just wanting to make sure... – 英律功 Dec 13 '10 at 12:20
There is numerical data also. The formula looks like this - =SUMIF(H6:H234,">0",C6:C236) but the greater than zero doesn't work for cells that start with letters. – Sean Tanner Dec 13 '10 at 12:26

I'm not sure of what you want to do exactly but if you are interested in the numerical value of the cell, you may have to use val() function on the cell but if you only want to see if there is something in the cell (alpha or numeric), you should compare it with a blank cell or empty cell using isblank() or isempty(). As you are comparing with >0, I guess isblank() is your best choice.

share|improve this answer
Hi there. I am trying to add the contents of a different column to the one that contains the data. Is there such a thing as "is not blank?" – Sean Tanner Dec 13 '10 at 13:39
It's been solved! Thanks for all of your help. The way to do it is to use <>. Thanks again. – Sean Tanner Dec 13 '10 at 13:56

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .