I hate to argue with the oracle :) but I still think my SUMIF forumla is simpler: =SUMIF(C5:C20,">01/01/75",B5:B20) Will give you the answsum of the cleared checks: =SUM(B5:B20)-C22 Will give you the uncleared Don't get me wrong - I'm in no doubt that Linda's formula is correct, and I'm sure it's technically better, but IMO there's time when you gotta KISS. HTH, Dave. -----Original Message----- From: 4office [mailto:4office@xxxxxxxxxxxxx] Sent: 14 November 2002 16:09 To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Using SumIF in XL2k Ok I'm confused: I don't want to COUNT the number of checks cleared... I need the SUM of the checks cleared... so do it do a Totaled Cleared: =SUMIF(B5:B20,DCOUNTA(C5:C20,1,C5:C20),B5:B20) Totaled outstanding: difference between all checks & Cleared checks Row A B C 4 check no amount cleared date 5 1001 541 25-Oct 6 1002 254 10-Oct 7 1003 654 26-Oct 8 1004 125 22-Oct 9 1005 741 10 1006 258 11 1007 745 29-Oct 12 1008 654 29-Oct 13 1009 987 14 1010 421 15 1011 451 30-Oct 16 1012 325 17 1013 325 18 1014 1452 19 1015 984 30-Oct 20 1016 555 -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of Linda F. Johnson Sent: Monday, November 11, 2002 11:58 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Using SumIF in XL2k Based on the info you gave below: The COUNTBLANK formula will count all the blank cells in a range and give you a total count of them. So, if there is nothing in the cleared date column, =COUNTBLANK(C5:C200) would give you a total of all checks not cleared....then DCOUNTA will count all the cells that are NOT blank in a database, so this formula would give you those: =DCOUNTA(C5:C20,1,C5:C20) Linda Publisher ~ ABC ~ All 'Bout Computers Owner ~ Linda's Computer Stop http://personal-computer-tutor.com FREE MS Office eBook Tutorial http://personal-computer-tutor.com/library.htm ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************