Thread
:
Counting in a spreadsheet
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
ryguy7272
external usenet poster
Posts: 2,836
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 With Quote
ryguy7272
View Public Profile
Find all posts by ryguy7272