Count AND arguments
 

Hi there,

I want to count the number of times two seperate things occure in
diffrent rows.

I want to count the times "v" appears in rows C7:AG7 AND the times
someting is put in rows e7:eG7.

So "something" in range e7:eg7 and "v" in range C7:AG7 should increase
the number that is put in A1.

How can I do this?

Thanks

Count AND arguments
 

Are you sure your cell and range references are correct? They seem to
overlap and are not the same size.

Pete

On Nov 1, 10:43 pm, Jeff wrote:
Hi there,

I want to count the number of times two seperate things occure in
diffrent rows.

I want to count the times "v" appears in rows C7:AG7 AND the times
someting is put in rows e7:eG7.

So "something" in range e7:eg7 and "v" in range C7:AG7 should increase
the number that is put in A1.

How can I do this?

Thanks

Count AND arguments
 

Woops,

Let say C6:AG6 should contain "v"
AND
C12:AG12 should not be empty

And I need to know how many times this appears

Thanks for pointing me out!




On Thu, 01 Nov 2007 15:48:33 -0700, Pete_UK
wrote:

Are you sure your cell and range references are correct? They seem to
overlap and are not the same size.

Pete

On Nov 1, 10:43 pm, Jeff wrote:
Hi there,

I want to count the number of times two seperate things occure in
diffrent rows.

I want to count the times "v" appears in rows C7:AG7 AND the times
someting is put in rows e7:eG7.

So "something" in range e7:eg7 and "v" in range C7:AG7 should increase
the number that is put in A1.

How can I do this?

Thanks

Count AND arguments
 

=SUMPRODUCT(--(C6:AG6="v"),--(C12:AG12<""))


--


Regards,


Peo Sjoblom


"Jeff" wrote in message
...
Woops,

Let say C6:AG6 should contain "v"
AND
C12:AG12 should not be empty

And I need to know how many times this appears

Thanks for pointing me out!




On Thu, 01 Nov 2007 15:48:33 -0700, Pete_UK
wrote:

Are you sure your cell and range references are correct? They seem to
overlap and are not the same size.

Pete

On Nov 1, 10:43 pm, Jeff wrote:
Hi there,

I want to count the number of times two seperate things occure in
diffrent rows.

I want to count the times "v" appears in rows C7:AG7 AND the times
someting is put in rows e7:eG7.

So "something" in range e7:eg7 and "v" in range C7:AG7 should increase
the number that is put in A1.

How can I do this?

Thanks

Count AND arguments
 

On Thu, 1 Nov 2007 16:11:12 -0700, "Peo Sjoblom"
wrote:

=SUMPRODUCT(--(C6:AG6="v"),--(C12:AG12<""))

Oh great!!
It works...

Can you please explain what the "--" means?

Thank you very much!!!!

Count AND arguments
 

Basically, it converts TRUEs and FALSEs to 1s and 0s, so they can be
used arithmetically. Here is a more detailed description:

http://www.mcgimpsey.com/excel/formulae/doubleneg.html

Hope this helps.

Pete

On Nov 1, 11:25 pm, Jeff wrote:
On Thu, 1 Nov 2007 16:11:12 -0700, "Peo Sjoblom"
wrote:

=SUMPRODUCT(--(C6:AG6="v"),--(C12:AG12<""))

Oh great!!
It works...

Can you please explain what the "--" means?

Thank you very much!!!!

Count AND arguments
 

Thanks again, you're a great help!!



On Fri, 02 Nov 2007 00:25:48 +0100, Jeff wrote:

On Thu, 1 Nov 2007 16:11:12 -0700, "Peo Sjoblom"
wrote:

=SUMPRODUCT(--(C6:AG6="v"),--(C12:AG12<""))

Oh great!!
It works...

Can you please explain what the "--" means?

Thank you very much!!!!

Count AND arguments
 

You're welcome, Jeff - thanks for the feedback.

Pete

"Jeff" wrote in message
...
Thanks again, you're a great help!!



On Fri, 02 Nov 2007 00:25:48 +0100, Jeff wrote:

On Thu, 1 Nov 2007 16:11:12 -0700, "Peo Sjoblom"
wrote:

=SUMPRODUCT(--(C6:AG6="v"),--(C12:AG12<""))

Oh great!!
It works...

Can you please explain what the "--" means?

Thank you very much!!!!