function

[external]

5060

i want to count that : A=1 and B="a" .
thank

+-------------------------------------------------------------------
|Filename: f.GIF
|Download: http://www.excelforum.com/attachment.php?postid=5060
+-------------------------------------------------------------------

 

[Guest]

=sumproduct(--(a1:a1000=1)*(b2:b1000="a"))

hth
regards from Brazil
Marcelo

"external" escreveu:

 

[external]

hi.
thanks for your reply.
But it is not working.
I want that count of row that A=1 and B="a".

help!!!
thankss...

 

[Dav]

You will have to make it clearer what you require. Give more detail
please

Regards

Dav

 

[bplumhoff]

=sumproduct(--(a1:a1000=1),--(b1:b1000="a"))

Regards,
Bernd

 

[external]

i want to find count of the row that A=1 and B="adana" ???
A B
1. 1 adana
2 2 adam
3 3 adana
4 1 adana


result=2!!!
( Because 1. and 4. row)

helpp!!
thanksss...

 

[Dav]

The suggestions you have been given shold work

=sumproduct((a1:a1000=1)*(b2:b1000="a"))

as suggested above is what I would use

Regards

dav

 

[bplumhoff]

There is a typo in there (should read B1, not B2).

This should work:
=sumproduct(--(a1:a4=1),--(b1:b4="adana"))

Regards,
Bernd

 

[external]

It stil is not working.

I trr that :

=sumproduct(--(Planli_calisma!B1:B4=1),--(Planli_calismaE1:E4="BITTI"))

Error Mesage=
If you are not trying to enter a formula,, avoi
using an equal sign(=) or minus sign(-), or precede it with a singl
quatation mark(').

helpp please.
thanks..

 

[external]

thakns for your help.
i try that and it is working:

=SUMPRODUCT((Planli_calisma!B1:B100=1)*(Planli_calisma!E1:E100="BITTI"))

but another problem: i want to control all rows.Not between 1-100
I try that:
=SUMPRODUCT((Planli_calisma!B:B=1)*(Planli_calisma!E:E="BITTI"))

but it is not working.How can i do ?
Thanks for all replies

 

[bplumhoff]

Hello,

You have a typo in your formula (a "!" is missing).

My examples were ok, I think. If you need more explanation, try
http://www.xldynamic.com/source/xld.SUMPRODUCT.html#explain

HTH,
Bernd

 

[external]

I am using MS EXCEL 2003.
I want to add date dynamicly (only MONTH)to a chart.
How can i do this?