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.
>>> >
>>>
>>>
>>>
>
>