# Please could someone help me with some a Numbers function?

Discussion in 'Mac Apps and Mac App Store' started by MasterHowl, Jun 25, 2013.

1. Jun 25, 2013
Last edited: Jun 25, 2013

### MasterHowl macrumors 65816

Joined:
Oct 3, 2010
Location:
North of England
#1
I'm counting sedimentary clasts tomorrow (don't ask...) and I need a spreadsheet to help me crunch the numbers.

I made little drop down menus yesterday so it's easy to input the clast type.

However, I need the total number of that type of clast in a different table (so I can ultimately make a pie chart of clast proportions).

Eg, if I see 25 Calcite clasts, I'll have selected "calcite" 25 times from the drop-down menus, and I need "25" to appear in the table in the screen shot below.

I think it's something to do with the SUMIF() function but I can't get it to work properly.

I hope explained myself properly! Thanks

PS: apologies for the mistake in the thread title!

2. Jun 25, 2013
Last edited: Jun 25, 2013

### invertedworld macrumors newbie

Joined:
Mar 23, 2003
Location:
England
#2
Try the COUNTIF function

Hi

If I understand you correctly, I think what you need is the COUNTIF function.

It takes two parameters. The first is the range that you want to search, which would be the column in your first table containing the selected items. The second parameter is the value that you're looking for. The result of the function is the number of cells within the range that contain that value.

Using your example, if you created a cell in your second table containing the formula =COUNTIF(Table 1 :: \$A, "Calcite"), it would return the number of cells in column A of Table 1 that contained the value "Calcite".

Hope this helps!

Mark

3. ### prisstratton macrumors 6502a

Joined:
Dec 20, 2011
Location:
#3
Here is how I would do it in Excel using the COUNTIF function. I assume Numbers can do the same.

File size:
205 KB
Views:
51
4. ### saberahul macrumors 68040

Joined:
Nov 6, 2008
Location:
USA
#4
In numbers and Excel, countif will do this as mentioned. In excel, a simple pivot will achieve the same thing. Put the clast composition in the row column and in the values box and it will give you same thing.

5. ### MasterHowl thread starter macrumors 65816

Joined:
Oct 3, 2010
Location:
North of England