Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting for multiple situations
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.... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting for multiple situations
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.... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting for multiple situations
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Various dates returned for variable situations, + | Excel Worksheet Functions | |||
Crashes when find is used (and specific situations) | Excel Discussion (Misc queries) | |||
work customizable situations problem | Setting up and Configuration of Excel | |||
Finding text strings in complex situations | Excel Discussion (Misc queries) | |||
conflicitng situations in shared workbook | Excel Discussion (Misc queries) |