Bear in mind this is an array formula. You'll need to press CTRL+SHIFT+ENTER when entering it in the cell. If ini doubt, see one of the many array formula articles on the web. Ray ------------------------------------ GR Business Process Solutions Ray Blake Head of Software Design ray@xxxxxxxxx Braedon Newell Road Hemel Hempstead Herts HP3 9PD tel: 01442 396518 fax: 01442 389353 mobile: 07834 226601 www.grbps.com ------------------------------------ -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Scott, Tiffani D. Sent: 26 August 2005 16:40 To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Countif I cannot get it to work still.....here is what I have: =3DSUM(IF(Allgier!A4:A100<>"",IF(Allgier!F4:F100=3D"",1,0),0)) Allgier is the name of the worksheet it is pulling information off of. The Range is A4:100. It is checking it anything is written in the cells. -------AND-------- And if a corresponding cell F4:F100 is empty I want it to be counted on the main page. Thank you, Tiffani ************************************************************* 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 *************************************************************