COUNTIF - Excel 2007

's Computer Specifications

Want to count how many times Column A is greater than Column B and looking
for the formula.
ex
A B

4 2
3 6
1 0

Want result of 2

's Computer Specifications

=SUMPRODUCT(--(A1:A100>B1:B100))

--

Regards,

Peo Sjoblom

"Railrd" <(E-Mail Removed)> wrote in message
news:34A17C32-00F4-4A73-9D49-(E-Mail Removed)...
> Want to count how many times Column A is greater than Column B and looking
> for the formula.
> ex
> A B
>
> 4 2
> 3 6
> 1 0
>
> Want result of 2

's Computer Specifications

Thank You VERY Much

"Peo Sjoblom" wrote:

> =SUMPRODUCT(--(A1:A100>B1:B100))
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
>
> "Railrd" <(E-Mail Removed)> wrote in message
> news:34A17C32-00F4-4A73-9D49-(E-Mail Removed)...
> > Want to count how many times Column A is greater than Column B and looking
> > for the formula.
> > ex
> > A B
> >
> > 4 2
> > 3 6
> > 1 0
> >
> > Want result of 2
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOW DO I USE COUNTIF FUNCTION ACCESS 2007 ?	Udaya	Microsoft Access Queries	3	26th Oct 2010 11:56 PM
Excel 2007 Multiple countif ??	Gerard Goodland	Microsoft Excel Misc	0	18th Oct 2009 11:28 PM
Countif and Sumif functions not working in Excel 2007	jmroehl	Microsoft Excel Worksheet Functions	3	3rd Aug 2009 03:40 PM
countif function excel 2007	Dave H	Microsoft Excel Worksheet Functions	1	14th May 2008 06:06 PM
CountIF function in Excel 2007 beta 1 tr 1	=?Utf-8?B?RGFubiBQZWRlcnNlbg==?=	Microsoft Excel Crashes	4	22nd Dec 2006 10:52 AM