| 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? |
| 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) | |||
Threaded Mode
