Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Prototype · 10-21-2010, 11:56 AM

If you can, have the A#'s in Column A, and the Open/Close in Column B.

In column C, insert this formula: =IF(A3=A2, 0, IF(B2="Open", 1, 0)), then go fill down to the cells below that you need a result.

Then do a =Sum(C2:C9) in C10.

Result should be 4.

PM me if you need me to email it to you.

10-21-2010, 11:56 AM	#3
Prototype Join Date: May 2004 Location: @robdashjamieson Exp:	If you can, have the A#'s in Column A, and the Open/Close in Column B. In column C, insert this formula: =IF(A3=A2, 0, IF(B2="Open", 1, 0)), then go fill down to the cells below that you need a result. Then do a =Sum(C2:C9) in C10. Result should be 4. PM me if you need me to email it to you. __________________ Last edited by Prototype; 10-21-2010 at 01:07 PM.