Count AND arguments

[Jeff]

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

 

[Pete_UK]

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

Pete

 

[Jeff]

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!

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[Jeff]

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

Oh great!!
It works...

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

Thank you very much!!!!

 

[Pete_UK]

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

 

[Jeff]

Thanks again, you're a great help!!

Oh great!!
It works...

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

Thank you very much!!!!

 

[Pete_UK]

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

Pete