LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default excel 2003-countif statement

How do I write this statement (or another appropriate one) to count the
number of entries that meet two criteria? The data is contained in two
different columns.

Example - what is the # of entries that contain the number 2 in a specific
range in column C AND the word "new" in a specific range in column D.


 
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
Countif within and if statement Amber Excel Worksheet Functions 2 July 30th 07 06:05 PM
COUNTIF for criteria in two separate columns (Excel 2003) Mimi Excel Worksheet Functions 5 January 11th 07 09:06 PM
If Statement with Countif Crazyhorse Excel Discussion (Misc queries) 3 April 10th 06 08:55 PM
COUNTIF Bug in Excel 2003 byundt Excel Worksheet Functions 5 July 22nd 05 03:51 PM
WHERE IS COUNTIF IN EXCEL 2003 Nimrod Excel Worksheet Functions 3 November 19th 04 02:46 AM


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

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

About Us

"It's about Microsoft Excel"