Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function
=sumproduct(--(a1:a1000=1),--(b1:b1000="a"))
Regards, Bernd |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function
There is a typo in there (should read B1, not B2).
This should work: =sumproduct(--(a1:a4=1),--(b1:b4="adana")) Regards, Bernd |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |