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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
You might consider this. Notice 500 for both instead of 502 and 500
=sumproduct((Info!$B$5:$B$500="May")*(Info!$L$5:$L $500=15)) if you are looking at real dates in col B instead of text for the months =sumproduct((month(Info!$B$5:$B$500)=5)*(Info!$L$5 :$L$500=15)) -- Don Guillett SalesAid Software "JohnD" wrote in message ... =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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Do you want countif to function if
ALL of B5:B502 are May or ANY of B5:B502 are May ?? -- Gary's Student "JohnD" wrote: =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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Hi John,
One possible reason in case of imported data that Excel doesn't treat them as text, not even if they are formatted as text. Try convert Info!B column with the TEXT function! Regards, Stefi €˛JohnD€¯ ezt Ć*rta: =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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
Brilliant, works a treat.
Cheers Don. "Don Guillett" wrote: You might consider this. Notice 500 for both instead of 502 and 500 =sumproduct((Info!$B$5:$B$500="May")*(Info!$L$5:$L $500=15)) if you are looking at real dates in col B instead of text for the months =sumproduct((month(Info!$B$5:$B$500)=5)*(Info!$L$5 :$L$500=15)) -- Don Guillett SalesAid Software "JohnD" wrote in message ... =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. |
Reply |
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 |