View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default 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.