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
|
|||
|
|||
counting
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 ? |
#2
|
|||
|
|||
counting
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 ? |
#3
|
|||
|
|||
counting
=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 |
Thread Tools | |
Display Modes | |
|
|