LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default COUNTIF - Excel 2007

Thank You VERY Much

"Peo Sjoblom" wrote:

=SUMPRODUCT(--(A1:A100B1:B100))


--


Regards,


Peo Sjoblom



"Railrd" wrote in message
...
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 Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pasting a chart from Excel 2007 to Word 2007 trouble Vegas Charts and Charting in Excel 5 September 16th 08 07:37 AM
How can you "save as" in excel 2007 (and word 2007)? gofordan Excel Discussion (Misc queries) 2 September 6th 07 09:52 PM
Exporting Quickbooks 2007 to Excel 2007 BShennum Excel Worksheet Functions 0 June 22nd 07 07:09 PM
Problems with my links to an excel 2007 file from a word 2007 file sc Links and Linking in Excel 0 February 21st 07 10:12 AM
Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr Bdhooper1 Excel Discussion (Misc queries) 1 July 19th 06 11:39 PM


All times are GMT +1. The time now is 05:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"