I have a table of data that contains labels, and the date that the values next to those labels are summed in one row, and the data itself in subsequent rows like this:A             B         CSM         10,291     $3.09RCOM        5,171    $11.96ED          4,752     $5.70RS         31,748    $27.41AO         50,745     $5.4106/25/16  102,707    $53.57I would like to have a master total cell that sums only the cells that contain totals.  So in English - Sum B if A is not text.I found the isnontext() function, and I know about sumif(), but I can't quite figure out how to make this work.  Hopefully that's clear and someone can point me in the right direction.
Google Sheets, how to sumif value in another row is a date?
google spreadsheets
Seems:=sumif(A:A,>1,B:B)  was adequate. There is no numeric value for text entries in a formula such as above, so they are ignored and only all the numeric ones need be 'captured', if the alternative to Text is only Date.