Excel Formula Question 2

[LupoLover]

Sorry guys, thought I better start a new thread as no one will read once other one solved (Many Thanks)

I have a colunm with loads of TRUE or FALSE in, and the same in another so say column A and B. I want a cell that will count which one has most TRUE and put a A or B in to say which has most. I know I got to use COUNT but I spent 2 hours messing around last night and cant get anything to work.

Cheers

Sheldon

 

[LupoLover]

Perfect, cheers guys

 

[LupoLover]

Oki guys I know Im a pain but this one I dont think is my fault!

I have in AQ9 : =AND(AP9=TRUE,AM9=TRUE)

AP9 and AM9 have formula in that then display TRUE.

Why does AQ9 still show FALSE?