Prev: create an expense requisition form
Next: Date and Time
From: Shane Devenshire on 14 May 2010 19:25
Be careful B2 is in the range B:B so you will be counting the criteria cell
of the COUNTIF function, do you really want to do that?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"psd364" wrote:

> I need to use a formula to find out how many times the value in B2 appears in
> column B.
From: Lars-�ke Aspelin on 14 May 2010 19:30
On Fri, 14 May 2010 16:24:01 -0700, Shane Devenshire
<ShaneDevenshire(a)discussions.microsoft.com> wrote:

>Excel 2003 does allow full column references with the COUNTIF function.

Thanks for pointing that out. I wasn't sure so I gave an alternative
solution too, just in case full column reference was not allowed.

Lars-�ke
First  |  Prev  | 
Pages: 1 2
Prev: create an expense requisition form
Next: Date and Time