counting
in [General]
|
From: pierre on 21 Apr 2010 15:55 hello i have cells from A1:A3 and A6:A10 which contain text strings. now what should be the formula if i want to count these cells ? (answer should be 8) what should also be the formula change if the cells would contain numbers ?
From: Mike H on 21 Apr 2010 16:17 Hmm, Is this homework, we don't normally do that here we point people in the right direction. Look in Excel help for COUNTA COUNT and you should be able to work it out. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "pierre" wrote: > hello > i have cells from A1:A3 and A6:A10 which contain text strings. > now what should be the formula if i want to count these cells ? (answer > should be 8) > > what should also be the formula change if the cells would contain numbers ? > >
From: Dave Peterson on 21 Apr 2010 16:20 =counta(a1:a3,a6:a10) will count the cells that have anything in them -- numbers, text, even formulas that evaluat to "". =count(a1:a3,a6:a10) will count the cells that only have numbers in them. pierre wrote: > > hello > i have cells from A1:A3 and A6:A10 which contain text strings. > now what should be the formula if i want to count these cells ? (answer > should be 8) > > what should also be the formula change if the cells would contain numbers ? -- Dave Peterson
|
Pages: 1 Prev: Orientation of text in an autoshape Next: how can I change MMDDYY to YYYYMMDD? |