|
|
#2
06-02-2013, 06:31 PM
|
||||
|
||||
Sure, Barry. That's what the COUNTIF function is about. If your column is (say) C13, then your formula would be =COUNTIF(C13,"COMPLETE") — as simple as that. If you use A1 notation, it's just =COUNTIF($M:$M,"COMPLETE"). That's for the whole column; you can specify only part of the column in the usual way, if you want.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help with formulas please | paul_pearson | Excel | 0 | 03-20-2013 06:51 AM |
 how to transfer multiple excel cells into specific place in word document by formulas
|
anton | Excel | 1 | 12-20-2011 03:56 AM |
|
IF Formulas
|
mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |
| Can't calculate formulas | Cpat | Excel | 2 | 06-09-2010 02:07 PM |
|
How to transfer multiple cells from excel to word by formulas
|
justziggy | Word | 5 | 05-23-2009 02:33 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode