Excel Help

I don't know if this will help, but have u tried going to Data ~> Pivot Tables? U'll have a new sheet created w/ the pivot tables and u see all ur data highly organized that way. Use the pull down menus and u can get what you're looking for.

 

The best way to do this, is to use a filter.

Highlight the data that you want to compare. Then go to data and filter. You will notice some drop down arrows on the top row. Click on the first arrow and select customize, then select equal to the value you need. Then select the next column and do the samething. that should give you the fields you need...

 

=IF(AND(A1=1,C1=3),1,0)
=IF(AND(A2=1,C2=3),1,0)
=IF(AND(A3=1,C3=3),1,0), etc.


The above states that if any in Column A is equal to 0 AND any in Column C is equal to 3, then Column X (X being the column where you enter this formula) is equal to 1, if not, then Column X is equal to 0.

To get the total, just add all the 1's in Column X.

Hope it makes sense.