Counting data in columns

[Mike Fellows]

ok ive struggled with this all morning and i cant do it


i have 2 columns

A and B

A can contain any of the following RTB, In Progress, Live

B contains a Date but can also be empty

I want to count column B (dates) where Column A is equal to RTB

but i have no idea how to do this

Example of Spreadsheet

A B
RTB 01/01/2003
Live 01/02/2003
RTB 01/02/2003
RTB 01/12/2003
Live 02/12/2003
RTB
RTB 01/01/2003
Live 01/10/2003


Total RTB count = 4

hope that helps

Thanks


Mike Fellows

 

[Max]

Try something like : =SUMPRODUCT((A1:A1000="RTB")*(B1:B1000<>""))

Adjust the range references, e.g.: A1:A1000, to suit.
(Both col ranges need to be identical and you can't use entire columns)