View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] coan.jim@gmail.com is offline
external usenet poster
 
Posts: 1
Default Excel Formula need help

I am trying to get a count of one column based on criteria in another
column

Column B always equals either 'true' or 'false'. I need to find a
count of 'true". (True being the test was taken)

so If A:A= 'test#3', then count # of 'trues' (in column B:B), related
to the same test name in A:A

Please help and thanks