Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
=IF(Info!$B$5:$B$502="May",COUNTIF(Info!$L$5:$L$50 0,"=15"),"0")
Why doesn't this formula work. Information is being pulled from an Access97 database into 'Info' worksheet. This information is then being analysed in another worksheet using this formula in one of the cells, but it doesn't recognise anything labelled 'May' seems count everything. Seperate cells for other months. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Excel formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Worksheet Functions | |||
I have a question regarding countif formula. | Excel Worksheet Functions |