Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif - shown blank cell
im trying to count the amount of times 'Red', blue, black etc is mentioned in
colounm K in worksheet 1, as i am entering the formula on a summary sheet. the problem is the the have entered the formula on the summary sheet; =COUNTIF('East & Park'!$E$5:$E$538,"Red") =COUNTIF('East & Park'!$E$5:$E$538,"Blue") etc etc but it doesnt work on the 'Red' it works for all the others apart from Red, iv checked the spelling and its the same and in the work sheet, so its not that, and i just dnt know how to correct this as i cant see the problem. can anyone help thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif - shown blank cell
Is there perhaps a leading or trailing space in Red?
Also, put Red in an empty cell, and copy this cell over all the other Red cells. Fixed then? -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Marie" wrote: im trying to count the amount of times 'Red', blue, black etc is mentioned in colounm K in worksheet 1, as i am entering the formula on a summary sheet. the problem is the the have entered the formula on the summary sheet; =COUNTIF('East & Park'!$E$5:$E$538,"Red") =COUNTIF('East & Park'!$E$5:$E$538,"Blue") etc etc but it doesnt work on the 'Red' it works for all the others apart from Red, iv checked the spelling and its the same and in the work sheet, so its not that, and i just dnt know how to correct this as i cant see the problem. can anyone help thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cells with zero value are shown as blank, not zero | Excel Discussion (Misc queries) | |||
Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
COUNTIF, dates and blank cell criteria | Excel Discussion (Misc queries) | |||
Tab Name Shown In Another Sheet's Cell | Excel Discussion (Misc queries) | |||
Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions |