function

  • Thread starter Thread starter external
  • Start date Start date
=sumproduct(--(a1:a1000=1)*(b2:b1000="a"))

hth
regards from Brazil
Marcelo

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

help!!!
thankss...
 
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...
 
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
 
There is a typo in there (should read B1, not B2).

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

Regards,
Bernd
 
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..
 
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
 
I am using MS EXCEL 2003.
I want to add date dynamicly (only MONTH)to a chart.
How can i do this?
 
Back
Top