|
|
#1
06-02-2013, 05:21 AM
|
|||
|
|||
Excel Formulas
I have a column of cells that at times the user will enter the words COMPLETE in certain rows of the column at certain times. Is there any way that I can formulate a cell that will count and add up the total number of cells marked COMPLETE as the user updates this column?
|
|
#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.
|
|
#3
06-03-2013, 04:27 AM
|
|||
|
|||
|
Thanks for the help Bob Bridges
|
|
|
|
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 64bit
Linear Mode
