Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WorkSheet Function Help
Try something like this:
For Questions in A1:A10 and Responses in B1:B10 A11: Yes B11: =COUNTIF(B1:B10,A11) A12: Yes B12: =COUNTIF(B1:B10,A12) Or perhaps this: B11: ="Yes count: "&COUNTIF(B1:B10,"Yes")&" No count: "&COUNTIF(B1:B10,"No") Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Dawn" wrote: I have created a basic worksheet where my column is asking a question such as is form signed and the user would have to answer either yes or no. I would like to create a formula that will automatically add up each yes and each no in the columns. Can someone help me write the formula please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a function to copy an entire worksheet? | Excel Worksheet Functions | |||
Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
Paste function is greyed out in the toolbar and I can't use ctl V - worksheet won't allow pasting | Excel Discussion (Misc queries) | |||
Is there a worksheet function that will... | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) |