Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting in a spreadsheet
I am creating a spreadsheet to keep track of how many people sign up for a
particular course. Is there a way that I can get a count of how many cells in a particular row have an x to give me a total number of participants who have signe up? Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting in a spreadsheet
Look in the help index for COUNTIF
-- Don Guillett Microsoft MVP Excel SalesAid Software "P. Zicari" wrote in message ... I am creating a spreadsheet to keep track of how many people sign up for a particular course. Is there a way that I can get a count of how many cells in a particular row have an x to give me a total number of participants who have signe up? Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting in a spreadsheet
Try something like this:
=SUMPRODUCT((A1:A10<"")*(B1:B10="x")) Read this for more info: http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards, Ryan--- -- RyGuy "Don Guillett" wrote: Look in the help index for COUNTIF -- Don Guillett Microsoft MVP Excel SalesAid Software "P. Zicari" wrote in message ... I am creating a spreadsheet to keep track of how many people sign up for a particular course. Is there a way that I can get a count of how many cells in a particular row have an x to give me a total number of participants who have signe up? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting dates in a spreadsheet.... | Excel Discussion (Misc queries) | |||
Formula for counting multiple variables in a spreadsheet | Excel Worksheet Functions | |||
Counting the number of checkboxes on a spreadsheet | Excel Worksheet Functions | |||
cells() and counting number or rows on spreadsheet | Excel Worksheet Functions | |||
Counting data in a spreadsheet | New Users to Excel |