Combination sumif() and isnumber()

[George]

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†? )

 

[Rick Rothstein \(MVP - VB\)]

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

=SUM(A1:A1000)

Rick

 

[George]

All the data arent numbers.

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

=SUM(A1:A1000)

Rick

 

[George]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Rick Rothstein \(MVP - VB\)]

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]

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

 

[scott]

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

 

[T. Valko]

Try this:

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

Or:

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

 

[Harlan Grove]

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

No, not possible.

 

[George]

Sometimes yes. I use vlookup() and sometimes there are some blank cells in
the list. In this case the result is an error msg in the column and cant sum
the column.