AND(), OR() in EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.
In general case, how can i use the AND() and OR() in a column?. For example
lets say that I have a column (A1:A100) with numbers, text and blank cells.
How can I say:

1) If one cell is number then give me the SUM of the column, else print “â€
2) If all cells are numbers then give me the SUM of the column, else print “â€

In those cases we use Cntrl + Shift + Enter?

Th.
 
Thank you. What about if all cells must be numbers to print SUM()?

Ο χÏήστης "Biff" έγγÏαψε:
 
Or, if your range isn't exactly A1:A100 (which is very easy to determine the
size of the range):

=IF(COUNT(A1:A100)=ROWS(A1:A100),SUM(A1:A100),"")

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set cell value to emptry if three other columns are empty too 1
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
isblank() function 6
Trouble flagging conditions in Excel using VB 6
Extracting data from range and placing in one cell with comma'sbetween while ignoring blanks 5
lookup and return column number 2
counting formula 3
IF, AND & OR 3

Back
Top