Sumif criteria that's not a blank

[mkclee]

I want to sum column B1:B5 if the column A1:A5 cells have a date in it.
I've tried SUMIF((A1:A5),isnumber,B1:B5). I've also trie
SUM(IF(ISNUMBER(A1:A5),B1:B5,0),0)

 

[JE McGimpsey]

Try

=SUMIF(A1:A25,"<>",B1:B25)

 

[uber_geek]

-----Original Message-----
I want to sum column B1:B5 if the column A1:A5 cells have a date in it.
I've tried SUMIF((A1:A5),isnumber,B1:B5). I've also tried
SUM(IF(ISNUMBER(A1:A5),B1:B5,0),0).