View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob K Rob K is offline
external usenet poster
 
Posts: 4
Default Need the correct formula

I am trying to count all the cells in a table that have a Category (first
column)of 'data' and a Priority (second column) of 'medium'. I can get a
count of all the cells with a value of 'medium' by using the 'CountIf'
function. But I can't seem to further restrict the count to just 'data' and
'medium'. I've tried the If-And function without sucess.

Thanks in advance
--
Rob K