AND(), OR() in EXCEL

[�ικο�]

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.

[Biff]

Hi!

My best guess is:

=IF(COUNT(A1:A100)>0,SUM(A1:A100),"")

Biff

"?????" <@discussions.microsoft.com> wrote in message
news:BFA3A0EF-EFE7-430F-AF2C-D4D4D8A12625@microsoft.com...
> 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" �*γγραψε:

> Hi!
>
> My best guess is:
>
> =IF(COUNT(A1:A100)>0,SUM(A1:A100),"")
>
> Biff
>
> "?????" <@discussions.microsoft.com> wrote in message
> news:BFA3A0EF-EFE7-430F-AF2C-D4D4D8A12625@microsoft.com...
> > 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.
> >
>
>
>

[Harald Staff]

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

HTH. Best wishes Harald

"?????" <@discussions.microsoft.com> skrev i melding
news:CC01F481-A070-4090-A522-1C9AFD694471@microsoft.com...
> Thank you. What about if all cells must be numbers to print SUM()?
>
> ? ??????? "Biff" ???????:
>
>> Hi!
>>
>> My best guess is:
>>
>> =IF(COUNT(A1:A100)>0,SUM(A1:A100),"")
>>
>> Biff
>>
>> "?????" <@discussions.microsoft.com> wrote in message
>> news:BFA3A0EF-EFE7-430F-AF2C-D4D4D8A12625@microsoft.com...
>> > 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.
>> >
>>
>>
>>

[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

"Harald Staff" <stf@enron.invalid> wrote in message
news:O8e7OcvrGHA.4960@TK2MSFTNGP04.phx.gbl...
> =IF(COUNT(A1:A100)=100,SUM(A1:A100),"")
>
> HTH. Best wishes Harald
>
> "?????" <@discussions.microsoft.com> skrev i melding
> news:CC01F481-A070-4090-A522-1C9AFD694471@microsoft.com...
>> Thank you. What about if all cells must be numbers to print SUM()?
>>
>> ? ??????? "Biff" ???????:
>>
>>> Hi!
>>>
>>> My best guess is:
>>>
>>> =IF(COUNT(A1:A100)>0,SUM(A1:A100),"")
>>>
>>> Biff
>>>
>>> "?????" <@discussions.microsoft.com> wrote in message
>>> news:BFA3A0EF-EFE7-430F-AF2C-D4D4D8A12625@microsoft.com...
>>> > 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.
>>> >
>>>
>>>
>>>
>
>