| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Function Help - COUNTIF
I'm trying to use COUNTIF to count the number of times a particular text
appears in a calendar range. when i do it, I keep getting a zero value. for instance "butterfly charm" appears 12X during the year. The formula is like this: =COUNTIF('2006 Calendar'!B3:H111,"Butterfly Charm") my chart is setup with the first column being the list of items and the second column being i.e. How Often Item Was Used, this is where I want the result to be. that chart is sheet 1. sheet 2 is a 2006 calendar. what am i doing wrong with the formula? does the problem lie with the calendar? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| CountIf function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| COUNTIF and then SUM in Same Function | Excel Worksheet Functions | |||
| hOW TO USE THE AND OPERATOR WITH THE COUNTIF FUNCTION | Excel Worksheet Functions | |||
Threaded Mode
