Hi Christine,
Have you tried just summing the cells with the bone counts in?
e.g. =SUM(c2:c100)
Alternatively if you highlight the cells with your fragment counts in
the total should be shown in the bottom right hand corner of the window.
Hope that helps,
Julia
Quoting "Kendrick, Christine" <[log in to unmask]>:
> Dear Zooarchers,
>
> I have a basic question regarding excel. It seems like it should be
> a simple matter to produce a NISP for a given species from an excel
> data sheet. I have tried a couple of different functions, such as
> COUNT, DCOUNT, COUNTIF; I suspect that I am producing an error in
> the nesting functions. Have any of you ever used Excel to do to a
> NISP? Would you be willing to provide me with instructions or an
> example? Any assistance is greatly appreciated!
>
> Cheers,
>
> Christine
>
Julia Elise Cussans
Division of AGES
University of Bradford
[log in to unmask]
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
|