SumIf using cells with a date as criteria

[Jimmy P]

In a worksheet cell I'm trying to sum a column of dollar amounts using SumIf to only include the amount in col B if col a has a date in it. I keep getting a "0" return.

The formula I have in B4 is =SumIf(A1:A3), "is(NotBlank", B1:B3). The sum should be the sum of B1 + B2.


A B

1 Date $1 2 Date $2 3 No Date $3 4 <tbody> </tbody>

<tbody>
</tbody>

 

[Joe4]

Dates are just stored in Excel as numbers. So just check for values greater than zero. Also note the range you are checking is the first argument, and the range you are summing is your last (you appear to have it backwards).

=SUMIF(B1:B3,">0",A1:A3)

 

[Jimmy P]

Wallah. Works great. Shoulda had a V8.

Mucho thanks.