Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
Hi, I have column B which can have a,0,1,sh as its input. I have another
column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
Please do not multipost, you have already received multiple answers to your
first post -- Regards, Peo Sjoblom "NM" wrote in message ... Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
See your other post for several replies.
You last statement seems to contradict what you ask for in the first paragraph. Pete On Nov 12, 4:45*pm, NM wrote: Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
Hi,
=SUMPRODUCT(--(B:B=1),--(C:C="I")) Cheers, Shane Devenshire "NM" wrote: Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
Shane,
you can only do this with XL2007 - for earlier versions you can't have full-column references with SP. Pete On Nov 12, 5:25*pm, Shane Devenshire wrote: Hi, =SUMPRODUCT(--(B:B=1),--(C:C="I")) Cheers, Shane Devenshire "NM" wrote: Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help.- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
Hi,
I did not see my first message posted ofr a long time , so I thought that the message did not got posted. Hence I reposted it. I apologise fo r the inconvenience. Thanks! "Peo Sjoblom" wrote: Please do not multipost, you have already received multiple answers to your first post -- Regards, Peo Sjoblom "NM" wrote in message ... Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
I'm sorry the last statement is a typo!It should read I do not want to count
the "I" in column c if column B has 0 or sh. Thanks! "Pete_UK" wrote: See your other post for several replies. You last statement seems to contradict what you ask for in the first paragraph. Pete On Nov 12, 4:45 pm, NM wrote: Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
Hi,
I am getting a #value error! Can you please help me. Thanks! "Shane Devenshire" wrote: Hi, =SUMPRODUCT(--(B:B=1),--(C:C="I")) Cheers, Shane Devenshire "NM" wrote: Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
I could fix the #value Error but the formula is giving me wrong answer!
"NM" wrote: Hi, I am getting a #value error! Can you please help me. Thanks! "Shane Devenshire" wrote: Hi, =SUMPRODUCT(--(B:B=1),--(C:C="I")) Cheers, Shane Devenshire "NM" wrote: Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
Hi,
I still cannot see where is my first post and the answers to it! I am still looking for an answer to my question. How can I locate my first post? search doesn't help me. Thanks! "Peo Sjoblom" wrote: Please do not multipost, you have already received multiple answers to your first post -- Regards, Peo Sjoblom "NM" wrote in message ... Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
Here's a link to your other post:
http://groups.google.com/group/micro...c72a17df3410aa Hope this helps. Pete On Nov 12, 6:35*pm, NM wrote: Hi, I still cannot see where is my first post and the answers to it! I am still looking for an answer to my question. How can I locate my first post? search doesn't help me. Thanks! "Peo Sjoblom" wrote: Please do not multipost, you have already received multiple answers to your first post -- Regards, Peo Sjoblom "NM" wrote in message ... Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help.- Hide quoted text - - Show quoted text - |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif with criteria
Hi,
=sumoroduct((rangeB=1)*(rangeC="I")) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "NM" wrote in message ... I could fix the #value Error but the formula is giving me wrong answer! "NM" wrote: Hi, I am getting a #value error! Can you please help me. Thanks! "Shane Devenshire" wrote: Hi, =SUMPRODUCT(--(B:B=1),--(C:C="I")) Cheers, Shane Devenshire "NM" wrote: Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column c only if Column B=1. I do not want to count the "I" in column c if column B has 0,1 or sh. Thanks for you help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Countif two criteria | Excel Discussion (Misc queries) | |||
COUNTIF - with more than one criteria | Excel Discussion (Misc queries) | |||
Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
countif criteria | Excel Worksheet Functions |