Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.