Combination sumif() and isnumber()

G

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

Rick Rothstein \(MVP - VB\)

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

=SUM(A1:A1000)

Rick
 
R

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
 
R

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
 
G

George

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

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
 
G

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