Count AND arguments

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 01 Nov 2007 23:43 GMT

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

Reply to this Message

Pete_UK - 01 Nov 2007 23:48 GMT

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

Pete

> Hi there,
>
[quoted text clipped - 10 lines]
>
> Thanks

Reply to this Message

Jeff - 01 Nov 2007 23:59 GMT

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!

>Are you sure your cell and range references are correct? They seem to
>overlap and are not the same size.
[quoted text clipped - 15 lines]
>>
>> Thanks

Reply to this Message

Peo Sjoblom - 02 Nov 2007 00:11 GMT

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

Signature

Regards,

Peo Sjoblom

> Woops,
>
[quoted text clipped - 25 lines]
>>>
>>> Thanks

Reply to this Message

Jeff - 02 Nov 2007 00:25 GMT

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

Oh great!!
It works...

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

Thank you very much!!!!

Reply to this Message

Pete_UK - 02 Nov 2007 01:00 GMT

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

> >=SUMPRODUCT(--(C6:AG6="v"),--(C12:AG12<>""))
>
[quoted text clipped - 4 lines]
>
> Thank you very much!!!!

Reply to this Message

Jeff - 02 Nov 2007 01:27 GMT

Thanks again, you're a great help!!

>>=SUMPRODUCT(--(C6:AG6="v"),--(C12:AG12<>""))
>
[quoted text clipped - 4 lines]
>
>Thank you very much!!!!

Reply to this Message

Pete_UK - 02 Nov 2007 02:11 GMT

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

Pete

> Thanks again, you're a great help!!
>
[quoted text clipped - 6 lines]
>>
>>Thank you very much!!!!

Reply to this Message