Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Total # Of Cells That Meet Several Criteria
Supervisor Sun Adam S Mower 11:00-16:00 Adam S Mower 11:00-19:30 Adam S Mower Off Adam S Mower 8:30-13:30 Candice S Carter Off Candice S Carter Off Candice S Carter 8:00-16:30 Chris S Uigaese 8:00-13:00 Chris S Uigaese Off Chris S Uigaese 12:00-20:00 Chris S Uigaese 8:00-16:30 Chris S Uigaese 8:00-16:30 I'm trying to make a formula that autmatically counts the number of "off"'s that appear in the chart above that are listed with a certain person... I just can't seem to come up with the function. Above is an example. The names are in a separate column. Any help? -- ashstudly ------------------------------------------------------------------------ ashstudly's Profile: http://www.excelforum.com/member.php...o&userid=30720 View this thread: http://www.excelforum.com/showthread...hreadid=503907 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Total # Of Cells That Meet Several Criteria
Hi,
Assuming that the data is in the range A1 to B100, and the person to whom you want the count is listed in cell C1, use this formula =SUMPRODUCT(($A$1:$A$100=C1)*(B1:B100="Off")) Regards Govind. ashstudly wrote: Supervisor Sun Adam S Mower 11:00-16:00 Adam S Mower 11:00-19:30 Adam S Mower Off Adam S Mower 8:30-13:30 Candice S Carter Off Candice S Carter Off Candice S Carter 8:00-16:30 Chris S Uigaese 8:00-13:00 Chris S Uigaese Off Chris S Uigaese 12:00-20:00 Chris S Uigaese 8:00-16:30 Chris S Uigaese 8:00-16:30 I'm trying to make a formula that autmatically counts the number of "off"'s that appear in the chart above that are listed with a certain person... I just can't seem to come up with the function. Above is an example. The names are in a separate column. Any help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Total # Of Cells That Meet Several Criteria
I can't believe how easy that was... I've tryingthat forever! Thank you so much! Here is another one...This time summing up the total for each person. Supervisor Total Adam S Mower 5.65 Adam S Mower 6.04 Adam S Mower 8.09 Adam S Mower 7.34 Candice S Carter 1.24 Candice S Carter Candice S Carter 1.98 Chris S Uigaese 2.43 Chris S Uigaese 9.78 Chris S Uigaese 4.33 Chris S Uigaese Chris S Uigaese 3.78 -- ashstudly ------------------------------------------------------------------------ ashstudly's Profile: http://www.excelforum.com/member.php...o&userid=30720 View this thread: http://www.excelforum.com/showthread...hreadid=503907 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Total # Of Cells That Meet Several Criteria
Hi,
Use =SUMPRODUCT(($A$1:$A$100=C1)*(B1:B100)) where A1 to A100 has the names of the supervisor and B1:B100 has the hours. C1 is the cell where you have typed out the name of the person for whom you need the total. Regards Govind. ashstudly wrote: I can't believe how easy that was... I've tryingthat forever! Thank you so much! Here is another one...This time summing up the total for each person. Supervisor Total Adam S Mower 5.65 Adam S Mower 6.04 Adam S Mower 8.09 Adam S Mower 7.34 Candice S Carter 1.24 Candice S Carter Candice S Carter 1.98 Chris S Uigaese 2.43 Chris S Uigaese 9.78 Chris S Uigaese 4.33 Chris S Uigaese Chris S Uigaese 3.78 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Total # Of Cells That Meet Several Criteria
Hi!
Try this: Use a cell to hold the criteria: C1 = Adam S Mower Names in column A, amounts in column B. =SUMIF(A1:A100,C1,B1:B100) Biff "ashstudly" wrote in message ... I can't believe how easy that was... I've tryingthat forever! Thank you so much! Here is another one...This time summing up the total for each person. Supervisor Total Adam S Mower 5.65 Adam S Mower 6.04 Adam S Mower 8.09 Adam S Mower 7.34 Candice S Carter 1.24 Candice S Carter Candice S Carter 1.98 Chris S Uigaese 2.43 Chris S Uigaese 9.78 Chris S Uigaese 4.33 Chris S Uigaese Chris S Uigaese 3.78 -- ashstudly ------------------------------------------------------------------------ ashstudly's Profile: http://www.excelforum.com/member.php...o&userid=30720 View this thread: http://www.excelforum.com/showthread...hreadid=503907 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum number of cells based on letter/title criteria | Excel Worksheet Functions | |||
counting total cells with text | Excel Discussion (Misc queries) | |||
Sum column if multiple criteria are met in adjacent cells | Excel Worksheet Functions | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
How can I count cells that meet two criteria within a filtered co. | Excel Worksheet Functions |