|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 3rd, 2006, 11:40 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Counta
I am using COUNTA to count data in a range of cells - the data in this instance is dates formatted as say Jan-06 - should work ok except that the formula is also counting cells which maybe blank but contain other formulas - what do I need to do to just return a result for the data as specified? -- martins ------------------------------------------------------------------------ martins's Profile: http://www.excelforum.com/member.php...o&userid=31616 View this thread: http://www.excelforum.com/showthread...hreadid=529414 
|
|
#2
April 3rd, 2006, 11:53 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Counta
Are these dates that are numeric? If so use COUNT instead of counta,
otherwise you can use =COUNTIF(A:A,"*?" ) to count text but not "" -- Regards, Peo Sjoblom http://nwexcelsolutions.com "martins" wrote in message ... I am using COUNTA to count data in a range of cells - the data in this instance is dates formatted as say Jan-06 - should work ok except that the formula is also counting cells which maybe blank but contain other formulas - what do I need to do to just return a result for the data as specified? -- martins ------------------------------------------------------------------------ martins's Profile: http://www.excelforum.com/member.php...o&userid=31616 View this thread: http://www.excelforum.com/showthread...hreadid=529414
|
|
#3
April 4th, 2006, 12:04 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Counta
"martins" wrote:
I am using COUNTA to count data in a range of cells - the data in this instance is dates formatted as say Jan-06 - should work ok except that the formula is also counting cells which maybe blank but contain other formulas - what do I need to do to just return a result for the data as specified? Try SUMPRODUCT with an additional criteria to exclude cells which are "blank" ("") something like the term: ... *(A1:A10"") .. within the example formula below: =SUMPRODUCT((A1:A10=--"7-Jan-2006")*(A1:A10"")) -- Max Singapore http://savefile.com/projects/236895 xdemechanik ---
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| COUNTA, COUNTIF? | Newbie | Worksheet Functions | 1 | March 18th, 2005 11:33 AM |
| Unable to Copy COUNTA() with cell references | EugenioB | Worksheet Functions | 1 | February 16th, 2005 01:07 PM |
| counta function | MP | Worksheet Functions | 4 | September 10th, 2004 05:06 PM |
| Repost - Using SUMIF and COUNTA | Max | Worksheet Functions | 4 | May 4th, 2004 07:07 AM |
| Repost - Using SUMIF and COUNTA | Peter | Worksheet Functions | 0 | May 3rd, 2004 01:36 PM |
Linear Mode
