AND(), OR() in EXCEL

  • Thread starter Îικος
  • Start date
Î

Îικος

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" έγγÏαψε:
 
B

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
 
Top