Hi,

I would use Sumproduct

=SUMPRODUCT((ISNUMBER(A1:A8))*(B1:B8))

Mike

"Tigerxxx" wrote:

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