Counting for multiple situations

I need to be able to count the number of times a meeting is scheduled (did
that) as well as the number times a meeting is canceled.
Assigned County Date
Occurred
FTM Worker Zip Code Time Frame Race Cancled,

or CO for Carry Over

to next mont
J. Finley Harris Other 3/3/2010
K. Gonzales Harris Other H Cancled
V. Glenn Harris Other H 3/3/2010
A. Elliott-Wilson Harris Other B 3/3/2010
K. Gonzales Harris Other W 3/4/2010
L. Lopez Harris 24 co
in the first column I used countif for each person's name to get the number
of times they have a meeting scheduled. There are other columns before the
name that are not relative to this issue. the 3 middle columns are also not
relaive and are just part of the spread sheet. In the last column I have
several countif to count if the meeting was held, cancled or carried over
(co). I need to be able to count the number of times each person actual
conducts there meetings.
Example:
K Gonzales has two meeting scheduled but only 1 actually took place becasue
it was cancled
L Lopez has 1 meeting scheduled but it was carried over to the next month.
How do I get excel to give me those numbers... Help, this is the last stat
that I am unable to calculate....

In Excel 2007 there is a COUNTIFS function that will allow you to specifiy
multiple criteria (like Name and if Date column="Cancled")

You can do the same with Sumproduct
=SUMPRODUCT(--(A1:A10="Someone"),--(E1:E10="Cancled"))

This site explains using conditions in a Sumproduct

http://xldynamic.com/source/xld.SUMPRODUCT.html

--
If this helps, please remember to click yes.


"Lisa" wrote:

I need to be able to count the number of times a meeting is scheduled (did
that) as well as the number times a meeting is canceled.
Assigned County Date
Occurred
FTM Worker Zip Code Time Frame Race Cancled,

or CO for Carry Over

to next mont
J. Finley Harris Other 3/3/2010
K. Gonzales Harris Other H Cancled
V. Glenn Harris Other H 3/3/2010
A. Elliott-Wilson Harris Other B 3/3/2010
K. Gonzales Harris Other W 3/4/2010
L. Lopez Harris 24 co
in the first column I used countif for each person's name to get the number
of times they have a meeting scheduled. There are other columns before the
name that are not relative to this issue. the 3 middle columns are also not
relaive and are just part of the spread sheet. In the last column I have
several countif to count if the meeting was held, cancled or carried over
(co). I need to be able to count the number of times each person actual
conducts there meetings.
Example:
K Gonzales has two meeting scheduled but only 1 actually took place becasue
it was cancled
L Lopez has 1 meeting scheduled but it was carried over to the next month.
How do I get excel to give me those numbers... Help, this is the last stat
that I am unable to calculate....

I typed in the following formula and got a value error

=SUMPRODUCT(--('FTM Stats 3-10'!I4:I67="k. gonzales"),--(E1:E10="Cancled"))

What am I doing wrong?????????
--
Lisa


"Paul C" wrote:

In Excel 2007 there is a COUNTIFS function that will allow you to specifiy
multiple criteria (like Name and if Date column="Cancled")

You can do the same with Sumproduct
=SUMPRODUCT(--(A1:A10="Someone"),--(E1:E10="Cancled"))

This site explains using conditions in a Sumproduct

http://xldynamic.com/source/xld.SUMPRODUCT.html

--
If this helps, please remember to click yes.


"Lisa" wrote:

I need to be able to count the number of times a meeting is scheduled (did
that) as well as the number times a meeting is canceled.
Assigned County Date
Occurred
FTM Worker Zip Code Time Frame Race Cancled,

or CO for Carry Over

to next mont
J. Finley Harris Other 3/3/2010
K. Gonzales Harris Other H Cancled
V. Glenn Harris Other H 3/3/2010
A. Elliott-Wilson Harris Other B 3/3/2010
K. Gonzales Harris Other W 3/4/2010
L. Lopez Harris 24 co
in the first column I used countif for each person's name to get the number
of times they have a meeting scheduled. There are other columns before the
name that are not relative to this issue. the 3 middle columns are also not
relaive and are just part of the spread sheet. In the last column I have
several countif to count if the meeting was held, cancled or carried over
(co). I need to be able to count the number of times each person actual
conducts there meetings.
Example:
K Gonzales has two meeting scheduled but only 1 actually took place becasue
it was cancled
L Lopez has 1 meeting scheduled but it was carried over to the next month.
How do I get excel to give me those numbers... Help, this is the last stat
that I am unable to calculate....

Hi Lisa,

Each array has to be same size, ie

=SUMPRODUCT(--('FTM Stats 3-10'!I4:I67="k. gonzales"),--
(E4:E67="Cancled"))

--
Per

On 22 Mar., 19:07, Lisa wrote:
I typed in the following formula and got a value error

=SUMPRODUCT(--('FTM Stats 3-10'!I4:I67="k. gonzales"),--(E1:E10="Cancled"))

What am I doing wrong????????? *
--
Lisa



"Paul C" wrote:
In Excel 2007 there is a COUNTIFS function that will allow you to specifiy
multiple criteria (like Name and if Date column="Cancled")

You can do the same with Sumproduct
=SUMPRODUCT(--(A1:A10="Someone"),--(E1:E10="Cancled"))

This site explains using conditions in a Sumproduct

http://xldynamic.com/source/xld.SUMPRODUCT.html

--
If this helps, please remember to click yes.

"Lisa" wrote:

I need to be able to count the number of times a meeting is scheduled (did
that) as well as the number times a meeting is canceled.
Assigned * * * * * * * * * County * * * * * * * * * * * * * * * * * * *Date
Occurred
FTM Worker * *Zip Code *Time Frame * Race * * Cancled,

* *or CO for Carry Over

* *to next mont
J. Finley * * * * * * * * * * Harris *Other * * * * * * * * * 3/3/2010
K. Gonzales * Harris *Other * * * H * Cancled
V. Glenn * * * * * * * * * * *Harris *Other * * * H * 3/3/2010
A. Elliott-Wilson * * Harris *Other * * * B * 3/3/2010
K. Gonzales * Harris *Other * * *W * *3/4/2010
L. Lopez * * * * * * * * * * *Harris *24 * * * * * * *co
in the first column I used countif for each person's name to get the number
of times they have a meeting scheduled. *There are other columns before the
name that are not relative to this issue. *the 3 middle columns are also not
relaive and are just part of the spread sheet. *In the last column I have
several countif to count if the meeting was held, cancled or carried over
(co). *I need to be able to count the number of times each person actual
conducts there meetings.
Example:
K Gonzales has two meeting scheduled but only 1 actually took place becasue
it was cancled
L Lopez has 1 meeting scheduled but it was carried over to the next month. *
How do I get excel to give me those numbers... Help, this is the last stat
that I am unable to calculate....- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -