Countif

boyntoni,

use this formula....

=SUM(IF(A1:A7=1,IF(C1:C7=1,1,0),0))

You need to press an hold CTRL and Shift when you press Return to get the {} mark's around the formula so it looks like the below.

{=SUM(IF(A1:A7=1,IF(C1:C7=1,1,0),0))}

You can change the ranges in red to suit (both need to cover the same amount of rows) and you can change the criteria in blue as well e.g. look for 2's

The first IF will check to see if column A contains a 1
The second IF will check to see if column C contains a 1
If they both meet the criteria it will count as 1, this will be applied and totaled for the ranges given.

Sxhall

Thanks so much for the help.

Just out of curiosity, why are the { } necessary?

Also, any idea on the window within the window?