| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 136319 | 2014-02-17 05:29:00 | An Excel forumula question | Digby (677) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1367903 | 2014-02-17 05:29:00 | A bit of a lame question I suppose but here goes. I have a spreadsheet where in one column I write the word yes in it if certain things apply. I'd like to be able to count the number of yesses. I can do it in Access (using count not null) but is there an excel formula ? Thanks |
Digby (677) | ||
| 1367904 | 2014-02-17 05:34:00 | COUNTIF :) | pcuser42 (130) | ||
| 1367905 | 2014-02-17 07:00:00 | Example: =COUNTIF(A1:A20,"Yes") Where A1:A20 is the column range you wish to count the yes's in. |
Jen (38) | ||
| 1367906 | 2014-02-17 07:20:00 | Brilliant Thanks - worked first time! |
Digby (677) | ||
| 1 | |||||