View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Keith L Keith L is offline
external usenet poster
 
Posts: 1
Default Formula for If - SUMIF

Excel 2003, what is the formula?

I have 2 columns of data. If there are X's in cells in column 1, I need to
count the number of coresponding cells in column 2 that have a specific
criteria (N/A).

Colimn 1 has an X or is blank, column 2 has 1, 2, 3, 4, 5 or N/A.
--
Thanks
Keith L