[mso] Re: Countif
- From: "Christine" <blue3123@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 25 Aug 2005 20:18:08 -0700
I sent this earlier today from work, but it doesn't seem to
have gotten to the list, so I'll try from home.
I think this might work.
=SUM(IF(A2:A10="ALLGIER",IF(F2:F10="",1,0),0)) Replace the
range A2:A10 and F2:F10 with your ranges.
Christine
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx
[mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Scott,
Tiffani D.
Sent: Thursday, August 25, 2005 1:58 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Countif
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).
//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=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).
//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
************************************************************
*
*************************************************************
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
*************************************************************
Other related posts:
