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: 69
Default CountIf for a range with multiple criteria

Hello. I want to make a count concerning two columns A and B.

The column A has text such as TT and TP the column B has numbers.

example
A B
TT 2
TP 5
TT 0
TT 1

I need to count how many times I have TT on columns A that the value on
column B is higher then 0

How?

Regards,
Marco


 
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
How do I put a date range in the criteria of a countif formula? hlpmelrn Excel Discussion (Misc queries) 3 November 23rd 06 03:12 AM
Excel COUNTIF Function - a range as criteria ? joes Excel Worksheet Functions 2 March 6th 06 01:13 PM
SUM(COUNTIF(range,NOT Criteria)) Santa-D Excel Worksheet Functions 3 January 31st 06 03:43 AM
use a date range as criteria in a countif formula mbparks Excel Worksheet Functions 3 January 2nd 05 11:06 PM
Countif with multiple criteria and multiple worksheets JJ Excel Worksheet Functions 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 07:36 PM.

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"