Tiffani Not very clear what you are trying to achieve her. So I set up a test sheet. Firstly, I like to use name ranges A3=Alpha, F3=Foxtrot A4:A13 name range set to Alpha F4:F13 name range set to Foxtrot On a row by row basis, this is simple, easy to check and works very well: In the next available column or even in a Workarea (somewhere to place intermediate code offset from the main screen area of your worksheet) use either of the following: =IF(AND(alpha<>"",ISBLANK(Foxtrot)),1,0) Or =IF(AND(Alpha<>"",Foxtrot=""),1,0) This will result in a 1 if both criteria are met on a single row or otherwise a zero. You can then easily total the column to give you the number of records/rows where both criteria are mmet. If you just want to calculate the number of rows where both criteria are met, type the following formula in the formula bar. =ROWS(Alpha)-SUM((Alpha<>"")*(Foxtrot="")) Ensuring that you enter this as an array formula, which necessitates that instead of just pressing the [Enter] key you hold [Shift]+[Ctrl] whilst pressing the [Enter] key. Regards Norman Pearce IT Training Manager Training & Development Department Developing the foundations for your success -----Original Message----- From: Scott, Tiffani D. [mailto:TScott@xxxxxxxxxxx] Sent: 17 August 2005 23:17 To: mso@xxxxxxxxxxxxx Subject: [mso] Countif Worksheet name: Allgier COUNTIF in the row, column F is blank and Column A has something in it. One of the many attempts I have made is as seen below: =COUNTIF(Allgier!F4:F100,("")&Countif(Allgier!A4:A100,(<>"") Thank you, T ************************************************************* 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 with the word "unsubscribe" (without the quotes) in the subject line. 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 with the word "unsubscribe" (without the quotes) in the subject line. 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 *************************************************************