# Excel Help

Discussion in 'Mac Apps and Mac App Store' started by R.Youden, Oct 27, 2006.

1. ### R.Youden macrumors 68020

Joined:
Apr 1, 2005
#1
Hi, I have a quik question bout Excel and any help would be fantastic.

OK I have a very large amout of data that I have collected for research in an Excel file. I have a number of columns all with values between 0 and 4. What I would like to do is count the number of times, for example. 0 appears in column A AND 3 appears in column C but only when they occur at the same time, not separately. I have looked through the help section of Excel and I can't find anything. Any help would be great, thanks.

Richard

2. ### n8236 macrumors 65816

Joined:
Mar 1, 2006
#2
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.

3. ### vi2867 macrumors 6502

Joined:
Oct 11, 2006
Location:
Eastvale, CA
#3
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...

4. ### noel4r macrumors 6502a

Joined:
Jul 17, 2002
Location:
Los Angeles
#4
=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.