View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marco Marco is offline
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