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.

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.

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.