Check 2 columns in range - count one

[Forestdog]

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 D274 and count all
the cells that equal '1'."

 

[Max]

In I2: =SUMPRODUCT((B2:B74=1)*(D274=1))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik

 

[Forestdog]

Thank you soooo much! I've wasted 4 hours with this and you've helped me 15
min! Have an awesome year!

 

[Max]

Welcome, Forestdog
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik