Everythime i look microsoft help it doesn't really explain it.
2007-02-18 05:00:58 · 5 answers · asked by pynghsbnd 1 in Education & Reference ➔ Homework Help
I use COUNTIF in Excel. I have a list of all my clothing purchases in there so I know how much each item cost and what year I bought it (and if it fits or not). Then at the bottom I've set a COUNTIF for each year, so it will add up how many items I bought in a particular year. This year I've been good and only bought 3 items, but last year I had a major spree and bought 19 items.
In strict technical terms, COUNTIF will count the number of records that match a given value. In my case, the value is the year of purchase, and each record is one item of clothing.
2007-02-18 16:35:27 · answer #1 · answered by Tertia 6 · 0⤊ 0⤋
Paul B is correct
Countif will count the number of occurences of whatever you set in the range of cells you give.
It can count the number of 1s or the number of FREDs in any given area of the spreadsheet.
2007-02-18 06:08:08 · answer #2 · answered by Anonymous · 2⤊ 0⤋
Its a function in Excel and is written COUNTIF. You give it a range and a value and it will return the number of times that value appear in the Range
e.g. in column A
X
Y
X
COUNTIF(A1:A3,"X") would return 2 because there are 2 X's in the cells A1 to A3
2007-02-18 05:12:39 · answer #3 · answered by Paul B 5 · 3⤊ 0⤋
counts the number of occurrences (in a range which you define) of the variable you give
2007-02-18 05:06:46 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Um..I think it means to count the number of words you have in the document...I am just guessing...I really don't know...Sorry...Good luck, though!
2007-02-18 05:05:54 · answer #5 · answered by Dee 6 · 0⤊ 1⤋