Maybe this:

=SUMPRODUCT(--(ISNUMBER(--A1:A10)),B1:B10)

--
Biff
Microsoft Excel MVP


"Tigerxxx" wrote in message
...
Actually I have alphabets in the series too; hence need to check the
condition specifically for "non-numerical" numbers.
Any ideas on how to write a condition for "non-numerical" numbers in a
"sumif" formula?

"T. Valko" wrote:

If the numbers in A2:A8 are always positive numbers then you can use
this:

=SUMIF(A2:A8,"=0",B2:B8)

If there might be negative numbers in A2:A8 then try this:

=SUMIF(A2:A8,"<1E100",B2:B8)

--
Biff
Microsoft Excel MVP


"Tigerxxx" wrote in message
...
Hello,

How can I write a "Sumifs" formula in Excel 2007 which sums only if the
range of a criteria contains numbers?
Example: if sum cells b2:b8 only if cells a2:a8 contain numbers.

Thank you