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.

Look in the help index for COUNTIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"P. Zicari" <(E-Mail Removed)> wrote in message
news:B509FDCE-B10C-437B-9349-(E-Mail Removed)...
>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.

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
> (E-Mail Removed)
> "P. Zicari" <(E-Mail Removed)> wrote in message
> news:B509FDCE-B10C-437B-9349-(E-Mail Removed)...
> >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.
>
>