Counting in a spreadsheet

[P. Zicari]

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.

 

[Don Guillett]

Look in the help index for COUNTIF

 

[ryguy7272]

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---