Hi to everyone.
Is it possible to combine somehow the functions SUMIF() and ISNUMBER() ?.
(For example, how can I say in Excel, at the end of a big column, filled of
miscellaneous data “Sum all the values that are numbers� ? )

Doesn't the SUM function work directly for you? For example,

=SUM(A1:A1000)

Rick


"George" <(E-Mail Removed)> wrote in message
news:6988C6EA-837F-4059-9769-(E-Mail Removed)...
> Hi to everyone.
> Is it possible to combine somehow the functions SUMIF() and ISNUMBER() ?.
> (For example, how can I say in Excel, at the end of a big column, filled
> of
> miscellaneous data “Sum all the values that are numbers� ? )
>

All the data arent numbers.

"Rick Rothstein (MVP - VB)" wrote:

> Doesn't the SUM function work directly for you? For example,
>
> =SUM(A1:A1000)
>
> Rick
>
>
> "George" <(E-Mail Removed)> wrote in message
> news:6988C6EA-837F-4059-9769-(E-Mail Removed)...
> > Hi to everyone.
> > Is it possible to combine somehow the functions SUMIF() and ISNUMBER() ?.
> > (For example, how can I say in Excel, at the end of a big column, filled
> > of
> > miscellaneous data “Sum all the values that are numbers� ? )
> >
>
>

Some cells include error msg (i use vlookup()) and the simple SUM dont work

"Rick Rothstein (MVP - VB)" wrote:

> Doesn't the SUM function work directly for you? For example,
>
> =SUM(A1:A1000)
>
> Rick
>
>
> "George" <(E-Mail Removed)> wrote in message
> news:6988C6EA-837F-4059-9769-(E-Mail Removed)...
> > Hi to everyone.
> > Is it possible to combine somehow the functions SUMIF() and ISNUMBER() ?.
> > (For example, how can I say in Excel, at the end of a big column, filled
> > of
> > miscellaneous data “Sum all the values that are numbers� ? )
> >
>
>

When I try SUM on a column of numbers and non-numbers, I get the total of
the numbers... doesn't SUM work the same for you?

Rick


"George" <(E-Mail Removed)> wrote in message
news:BD3F7265-114C-4FA6-82DE-(E-Mail Removed)...
> All the data arent numbers.
>
> "Rick Rothstein (MVP - VB)" wrote:
>
>> Doesn't the SUM function work directly for you? For example,
>>
>> =SUM(A1:A1000)
>>
>> Rick
>>
>>
>> "George" <(E-Mail Removed)> wrote in message
>> news:6988C6EA-837F-4059-9769-(E-Mail Removed)...
>> > Hi to everyone.
>> > Is it possible to combine somehow the functions SUMIF() and ISNUMBER()
>> > ?.
>> > (For example, how can I say in Excel, at the end of a big column,
>> > filled
>> > of
>> > miscellaneous data “Sum all the values that are numbers� ? )
>> >
>>
>>

Ah, information you neglected to mention in your first two messages.<g>

Try this array-entered** formula...

=SUM(IF(ISERROR(A1:A8),0,A1:A8))

** Commit the formula by pressing Ctrl+Shift+Enter instead of just Enter

Rick


"George" <(E-Mail Removed)> wrote in message
news:F202228A-CE34-467F-A6D1-(E-Mail Removed)...
> Some cells include error msg (i use vlookup()) and the simple SUM dont
> work
>
> "Rick Rothstein (MVP - VB)" wrote:
>
>> Doesn't the SUM function work directly for you? For example,
>>
>> =SUM(A1:A1000)
>>
>> Rick
>>
>>
>> "George" <(E-Mail Removed)> wrote in message
>> news:6988C6EA-837F-4059-9769-(E-Mail Removed)...
>> > Hi to everyone.
>> > Is it possible to combine somehow the functions SUMIF() and ISNUMBER()
>> > ?.
>> > (For example, how can I say in Excel, at the end of a big column,
>> > filled
>> > of
>> > miscellaneous data “Sum all the values that are numbers� ? )
>> >
>>
>>

Thanks. I try it.
(But just to know, in general, is it possible to combine the two functions ?)

"Rick Rothstein (MVP - VB)" wrote:

> Ah, information you neglected to mention in your first two messages.<g>
>
> Try this array-entered** formula...
>
> =SUM(IF(ISERROR(A1:A8),0,A1:A8))
>
> ** Commit the formula by pressing Ctrl+Shift+Enter instead of just Enter
>
> Rick
>
>
> "George" <(E-Mail Removed)> wrote in message
> news:F202228A-CE34-467F-A6D1-(E-Mail Removed)...
> > Some cells include error msg (i use vlookup()) and the simple SUM dont
> > work
> >
> > "Rick Rothstein (MVP - VB)" wrote:
> >
> >> Doesn't the SUM function work directly for you? For example,
> >>
> >> =SUM(A1:A1000)
> >>
> >> Rick
> >>
> >>
> >> "George" <(E-Mail Removed)> wrote in message
> >> news:6988C6EA-837F-4059-9769-(E-Mail Removed)...
> >> > Hi to everyone.
> >> > Is it possible to combine somehow the functions SUMIF() and ISNUMBER()
> >> > ?.
> >> > (For example, how can I say in Excel, at the end of a big column,
> >> > filled
> >> > of
> >> > miscellaneous data “Sum all the values that are numbers� ? )
> >> >
> >>
> >>
>
>

Normally the math works if there is text in the column.
Errors in the column seem to cause math calculation problems though.
Do you have errors in the column you arre calculating?
Scott

On Fri, 22 Feb 2008 10:20:03 -0800, George
<(E-Mail Removed)> wrote:

>Hi to everyone.
>Is it possible to combine somehow the functions SUMIF() and ISNUMBER() ?.
>(For example, how can I say in Excel, at the end of a big column, filled of
>miscellaneous data “Sum all the values that are numbers” ? )

Try this:

=SUMIF(A:A,"<"&1E100)

Or:

=SUMIF(A:A,"<1E100")


--
Biff
Microsoft Excel MVP


"George" <(E-Mail Removed)> wrote in message
news:76C80499-890C-4EAA-9754-(E-Mail Removed)...
> Thanks. I try it.
> (But just to know, in general, is it possible to combine the two functions
> ?)
>
> "Rick Rothstein (MVP - VB)" wrote:
>
>> Ah, information you neglected to mention in your first two messages.<g>
>>
>> Try this array-entered** formula...
>>
>> =SUM(IF(ISERROR(A1:A8),0,A1:A8))
>>
>> ** Commit the formula by pressing Ctrl+Shift+Enter instead of just Enter
>>
>> Rick
>>
>>
>> "George" <(E-Mail Removed)> wrote in message
>> news:F202228A-CE34-467F-A6D1-(E-Mail Removed)...
>> > Some cells include error msg (i use vlookup()) and the simple SUM dont
>> > work
>> >
>> > "Rick Rothstein (MVP - VB)" wrote:
>> >
>> >> Doesn't the SUM function work directly for you? For example,
>> >>
>> >> =SUM(A1:A1000)
>> >>
>> >> Rick
>> >>
>> >>
>> >> "George" <(E-Mail Removed)> wrote in message
>> >> news:6988C6EA-837F-4059-9769-(E-Mail Removed)...
>> >> > Hi to everyone.
>> >> > Is it possible to combine somehow the functions SUMIF() and
>> >> > ISNUMBER()
>> >> > ?.
>> >> > (For example, how can I say in Excel, at the end of a big column,
>> >> > filled
>> >> > of
>> >> > miscellaneous data "Sum all the values that are numbers" ? )
>> >> >
>> >>
>> >>
>>
>>

George <Geo...@discussions.microsoft.com> wrote...
....
>(But just to know, in general, is it possible to combine the two
>functions ?)

No, not possible.