I am trying to do something like this Countif(AND(A1:A10,1),(B1:B10,€� €œ)) but
it doesn't work
Thanks for any help

oldjay

Hi,

you mean something like?

worksheetfunction.Countif(AND(A1:A10,1),(B1:B10," "))

Regards,
Ivan

no I need an in cell formula

"Ivan Raiminius" wrote:

Hi,

you mean something like?

worksheetfunction.Countif(AND(A1:A10,1),(B1:B10," "))

Regards,
Ivan

so, something like this array formula:
=SUM(IF(A1:A10=1,IF(B1:B10="",1,0),0))

Regards,
Ivan

Thanks - worked!!

"Ivan Raiminius" wrote:

so, something like this array formula:
=SUM(IF(A1:A10=1,IF(B1:B10="",1,0),0))

Regards,
Ivan

Hi there,

It can be pretty tricky to try to figure out what someone's after if the
problem description is as brief as yours. If I see a post stating that "It
doesn't work" I won't really have a fighting chance of understanding your
problem, and coming up with a potential solution. Hoewever, if you provide
some more information I'm sure the members of this forum will be able to help
you.

Hence, please state at least the following:

- Exactly what you're trying to achieve
- The steps to take to reproduce your problem
- What happens when you execute those steps
- What you believe should have happened instead

Cheers,
/MP

"Oldjay" wrote:

I am trying to do something like this Countif(AND(A1:A10,1),(B1:B10,€� €œ)) but
it doesn't work
Thanks for any help

oldjay

Thanks for answering but the solution that Ivan give me worked

"Mat P:son" wrote:

Hi there,

It can be pretty tricky to try to figure out what someone's after if the
problem description is as brief as yours. If I see a post stating that "It
doesn't work" I won't really have a fighting chance of understanding your
problem, and coming up with a potential solution. Hoewever, if you provide
some more information I'm sure the members of this forum will be able to help
you.

Hence, please state at least the following:

- Exactly what you're trying to achieve
- The steps to take to reproduce your problem
- What happens when you execute those steps
- What you believe should have happened instead

Cheers,
/MP

"Oldjay" wrote:

I am trying to do something like this Countif(AND(A1:A10,1),(B1:B10,€� €œ)) but
it doesn't work
Thanks for any help

oldjay

Hehehe, I s'pose that's good enough then, and Ivan is obviously a clever
guy... :-)

Cheers,
/MP

"Oldjay" wrote:

Thanks for answering but the solution that Ivan give me worked

"Mat P:son" wrote:

Hi there,

It can be pretty tricky to try to figure out what someone's after if the
problem description is as brief as yours. If I see a post stating that "It
doesn't work" I won't really have a fighting chance of understanding your
problem, and coming up with a potential solution. Hoewever, if you provide
some more information I'm sure the members of this forum will be able to help
you.

Hence, please state at least the following:

- Exactly what you're trying to achieve
- The steps to take to reproduce your problem
- What happens when you execute those steps
- What you believe should have happened instead

Cheers,
/MP

"Oldjay" wrote:

I am trying to do something like this Countif(AND(A1:A10,1),(B1:B10,€� €œ)) but
it doesn't work
Thanks for any help

oldjay