GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2011-05 > 1305310713


From: "Diana Gale Matthiesen" <>
Subject: Re: [DNA] I1 haplogroup modal
Date: Fri, 13 May 2011 14:18:33 -0400
References: <00cd01cc1194$9cd6b310$d6841930$@dgmweb.net><BANLkTi=gHNEdaUKBLsTCsO4oQmR38411qQ@mail.gmail.com>
In-Reply-To: <BANLkTi=gHNEdaUKBLsTCsO4oQmR38411qQ@mail.gmail.com>


Thank you for the variations, Vince. Can you tell I don't use Excel
very often?

Diana

> From: Vince Tilroe
> Sent: Friday, May 13, 2011 1:54 PM
>
> Where [range] is defined as a single column, i.e. C1..C2000,
>
> Number of cells: =rows([range])
>
> Number of cells that contain numbers: =count([range])
>
> Number of cells that are not blank: =counta([range])
>
> Number of cells that do not contain numbers: =rows([range])-
> count([range])
>
> Number of cells that are blank: =rows([range])-counta([range])

This thread: