Wildlife Study: How do I sum entries by type and display only those types with 5+ entries

I am working on analyzing a bunch of data from a wildlife study, and I really need to find a formula. The data has Month and Day entries for each animal tagged at a particular site. The statistical analysis program will not run if there are too few entries for a given month/day category. What I need to do is have a formula that will sum up the to the total number of same month/day entries and discard month/day rows where there are less than 5 total entries.

Thanks!

- J

Attachment 455301

you could use a pivot table
to group and then filter

or a helper column

assuming
year_month_column in A
Day in C

countifs( A:A, A2, C:C, C2 )
then use an IF
IF( countifs( A:A, A2, C:C, C2 ) < = 5 , 0, 1) - copy down
and then filter on the new column

rather than images - attach a spreadsheet - saves members trying to create a sample sheet for you

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

what is you are summing on the sheet ?

Heres the helper column and count
With the helper column you can use a pivot table
and use the helper as a page filter and choose 1 - so the calc only uses values greater than 5

but not sure what you want to sum on the sheet ?

I just had to filter out days with too few entries. They were throwing off a statistical program. Your original post with the countif, if(countif), and filter did the trick. I was able to filter out all days where not enough specimens were collected. Now the statistical program works! Your suggestion did the trick - Thanks again!

-Julian

you are welcome