Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check 2 columns in range - count one
Simply, I just want the frequency of times that a 1 appears in the B and D
columns. So if there is a 1 in B then I want to know how many times (sum) there is also a corresponding 1 in the D column? This is how I explained it to a professor (who couldn't help)... "I need a formula for cell I2 that says, "look in the range B2:B74, where it equals '1', then look at the corresponding cell in range D2:D74 and count all the cells that equal '1'." |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check 2 columns in range - count one
In I2: =SUMPRODUCT((B2:B74=1)*(D2:D74=1))
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Forestdog" wrote: Simply, I just want the frequency of times that a 1 appears in the B and D columns. So if there is a 1 in B then I want to know how many times (sum) there is also a corresponding 1 in the D column? This is how I explained it to a professor (who couldn't help)... "I need a formula for cell I2 that says, "look in the range B2:B74, where it equals '1', then look at the corresponding cell in range D2:D74 and count all the cells that equal '1'." |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check 2 columns in range - count one
Thank you soooo much! I've wasted 4 hours with this and you've helped me 15
min! Have an awesome year! "Max" wrote: In I2: =SUMPRODUCT((B2:B74=1)*(D2:D74=1)) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Forestdog" wrote: Simply, I just want the frequency of times that a 1 appears in the B and D columns. So if there is a 1 in B then I want to know how many times (sum) there is also a corresponding 1 in the D column? This is how I explained it to a professor (who couldn't help)... "I need a formula for cell I2 that says, "look in the range B2:B74, where it equals '1', then look at the corresponding cell in range D2:D74 and count all the cells that equal '1'." |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check 2 columns in range - count one
Welcome, Forestdog
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Forestdog" wrote in message ... Thank you soooo much! I've wasted 4 hours with this and you've helped me 15 min! Have an awesome year! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count a range of cells from another columns criteria | Excel Worksheet Functions | |||
count if using columns not range of cells | Excel Worksheet Functions | |||
How to check for a date range match in one column and then count thevalues equal to in another | Excel Worksheet Functions | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
count all the columns in a range with certain conditions | Excel Discussion (Misc queries) |