function
 

5060

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


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

--
external
------------------------------------------------------------------------
external's Profile: http://www.excelforum.com/member.php...o&userid=36592
View this thread: http://www.excelforum.com/showthread...hreadid=563323

function
 

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

hth
regards from Brazil
Marcelo

"external" escreveu:


5060

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


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

--
external
------------------------------------------------------------------------
external's Profile: http://www.excelforum.com/member.php...o&userid=36592
View this thread: http://www.excelforum.com/showthread...hreadid=563323

function
 

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

help!!!
thankss...


--
external
------------------------------------------------------------------------
external's Profile: http://www.excelforum.com/member.php...o&userid=36592
View this thread: http://www.excelforum.com/showthread...hreadid=563323

function
 

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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=563323

function
 

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

Regards,
Bernd

function
 

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...


--
external
------------------------------------------------------------------------
external's Profile: http://www.excelforum.com/member.php...o&userid=36592
View this thread: http://www.excelforum.com/showthread...hreadid=563323

function
 

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=563323

function
 

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

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

Regards,
Bernd

function
 

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,, avoid
using an equal sign(=) or minus sign(-), or precede it with a single
quatation mark(').

helpp please.
thanks...


--
external
------------------------------------------------------------------------
external's Profile: http://www.excelforum.com/member.php...o&userid=36592
View this thread: http://www.excelforum.com/showthread...hreadid=563323

function
 

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

=SUMPRODUCT((Planli_calisma!B1:B100=1)*(Planli_cal isma!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.


--
external
------------------------------------------------------------------------
external's Profile: http://www.excelforum.com/member.php...o&userid=36592
View this thread: http://www.excelforum.com/showthread...hreadid=563323

function
 

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....T.html#explain

HTH,
Bernd

function
 

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


--
external
------------------------------------------------------------------------
external's Profile: http://www.excelforum.com/member.php...o&userid=36592
View this thread: http://www.excelforum.com/showthread...hreadid=563323