Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 question
I am trying to count conditional data that is true in 2 columns. Such as If
column = green and column b = south then count it. I need it to go through about 100 rows of data and have it tell me how many times I get a true on both conditions. Any ideas? I have tried nesting an if statment in a countif, and vis versa, and also tried nesting some ifs, but to no avail. Any help would be great!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 question
Let's say your data for GREEN is in A1:A100 and the data for SOUTH is in
B1:B100 =sumproduct(--(A1:A100="green"),--(B1:B100="south)) "CorinDarksoul" wrote: I am trying to count conditional data that is true in 2 columns. Such as If column = green and column b = south then count it. I need it to go through about 100 rows of data and have it tell me how many times I get a true on both conditions. Any ideas? I have tried nesting an if statment in a countif, and vis versa, and also tried nesting some ifs, but to no avail. Any help would be great!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 question
=SUMPRODUCT(--(A2:A200="green"),--(B2:B200="south))
for details see http://www.xldynamic.com/source/xld.SUMPRODUCT.html http://mcgimpsey.com/excel/formulae/doubleneg.html -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "CorinDarksoul" wrote in message ... I am trying to count conditional data that is true in 2 columns. Such as If column = green and column b = south then count it. I need it to go through about 100 rows of data and have it tell me how many times I get a true on both conditions. Any ideas? I have tried nesting an if statment in a countif, and vis versa, and also tried nesting some ifs, but to no avail. Any help would be great!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 question
Correction:
=sumproduct(--(A1:A100="green"),--(B1:B100="south)) should be =sumproduct(--(A1:A100="green"),--(B1:B100="south")) "Barb Reinhardt" wrote: Let's say your data for GREEN is in A1:A100 and the data for SOUTH is in B1:B100 =sumproduct(--(A1:A100="green"),--(B1:B100="south)) "CorinDarksoul" wrote: I am trying to count conditional data that is true in 2 columns. Such as If column = green and column b = south then count it. I need it to go through about 100 rows of data and have it tell me how many times I get a true on both conditions. Any ideas? I have tried nesting an if statment in a countif, and vis versa, and also tried nesting some ifs, but to no avail. Any help would be great!!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 question
Thank you thank you!! this solved my problem and gave me the answer I needed!
I may get my report done on time now! Thanks again!! "Bernard Liengme" wrote: =SUMPRODUCT(--(A2:A200="green"),--(B2:B200="south)) for details see http://www.xldynamic.com/source/xld.SUMPRODUCT.html http://mcgimpsey.com/excel/formulae/doubleneg.html -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "CorinDarksoul" wrote in message ... I am trying to count conditional data that is true in 2 columns. Such as If column = green and column b = south then count it. I need it to go through about 100 rows of data and have it tell me how many times I get a true on both conditions. Any ideas? I have tried nesting an if statment in a countif, and vis versa, and also tried nesting some ifs, but to no avail. Any help would be great!!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel 2003 question
Thank you very much! This is the answer I was looking for.
"Barb Reinhardt" wrote: Correction: =sumproduct(--(A1:A100="green"),--(B1:B100="south)) should be =sumproduct(--(A1:A100="green"),--(B1:B100="south")) "Barb Reinhardt" wrote: Let's say your data for GREEN is in A1:A100 and the data for SOUTH is in B1:B100 =sumproduct(--(A1:A100="green"),--(B1:B100="south)) "CorinDarksoul" wrote: I am trying to count conditional data that is true in 2 columns. Such as If column = green and column b = south then count it. I need it to go through about 100 rows of data and have it tell me how many times I get a true on both conditions. Any ideas? I have tried nesting an if statment in a countif, and vis versa, and also tried nesting some ifs, but to no avail. Any help would be great!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Help in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |