Not sure what formula to use

[awrex]

Hi..


I'd like to count column 1 if a cell in col2 or col3 contains data.

I was looking at vlookup & countif & countifs, however I keep getting errors or a 0 return when I know I shouldn't.

Thanks!

 

[Lidsavr]

awrex,
First welcome to the board. In the future, you need to tell us what version of Excel you are running and you need to be more specific about what you are doing.

It sounds like you need to use an "IF" statement.

=IF(COUNTIF(B:B,B1)>0,COUNT(A:A))

This assumes Column B (Column 2) contains a predetermined value in Cell B1, then it counts everything in Column A (Column 1).

I am guessing because your description did not go into detail. I hope this helps. You can always reply back with more information, or repost a new question.

Regards,

Charles

 

[awrex]

Thanks and sorry!

Using Excel 2007..

I have three columns of data... I need to count column 1 and see how many matches I have with col 2 & col 3.

Department Session 1 Session2
------------------------------------------------------------------
Sales Tom
Marketing Bob Bob
Accounting Bob
Logistics Tom Tom


Basically I have to count who attended the sessions by department.

I hope this is enough.. thanks again!