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.

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.

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.

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.

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.

Formula Question
 

glad to help

--
Don Guillett
SalesAid Software

"JohnD" wrote in message
...
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.