# SumIf using cells with a date as criteria

#### Jimmy P

##### New Member
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>

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### Joe4

##### MrExcel MVP, Junior Admin
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).
Code:
``=SUMIF(B1:B3,">0",A1:A3)``

#### Jimmy P

##### New Member
Wallah. Works great. Shoulda had a V8.

Mucho thanks.

Replies
10
Views
969
Replies
5
Views
352
Replies
1
Views
647
Replies
1
Views
447
Replies
17
Views
2K

Threads
1,190,913
Messages
5,983,532
Members
439,848
Latest member
timmyo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back