# [mso] Re: Countif

• From: "Scott, Tiffani D." <TScott@xxxxxxxxxxx>
• To: <mso@xxxxxxxxxxxxx>
• Date: Thu, 25 Aug 2005 14:58:01 -0600

```I appreciate your assistance and I do apologize but I am still confused.
If I can get this to work I will be able to apply it to most of the
documents I work with and will save me a lot of time daily.
--------------------------------------

On the worksheet named- SUMMARY, in Cell-B5, I would like a Count of
occurrences that meet both criteria's below: =20

Look on the worksheet named-ALLGIER, in Column A to see if there is
anything in that cell, (*note*-the data doesn't start until Row 4).

------AND-------

If the same Row of that cell has nothing in Column F

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Scott, Tiffani D.
Sent: Wednesday, August 24, 2005 12:30 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Countif

I sent this last week with no input.  If any one has some ideas please
send me a message.=3D20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of=3D20
Sent: Wednesday, August 17, 2005 4:17 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Countif

=3D20
Worksheet name: Allgier

COUNTIF in the row, column F is blank and Column A has something in it.

=3D20

One of the many attempts I have made is as seen below:

=3D20

=3D3DCOUNTIF(Allgier!F4:F100,("")&Countif(Allgier!A4:A100,(<>"")

=3D20

=3D20

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=3D20
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).
http://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,

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=20
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).
http://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,

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).
http://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
http://www.smartgroups.com/vault/msofiles
*************************************************************
```