Combination sumif() and isnumber()

  • Thread starter Thread starter George
  • Start date Start date
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†? )
 
Doesn't the SUM function work directly for you? For example,

=SUM(A1:A1000)

Rick
 
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
 
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
 
Thanks. I try it.
(But just to know, in general, is it possible to combine the two functions ?)
 
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
 
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.
 
Back
Top