Thread: Which Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kmaki kmaki is offline
external usenet poster
 
Posts: 11
Default Which Formula

My file is a 13 page document, 2 files per page capturing variou data. In
one column there are 5 rows where the data is either x or no. I am trying to
set up a formula that will give me 1) a total of all "x" and "no"; 2 a total
of all "x" only; 3) total of all "no" only.

One page I have rows 379:383 and 388:392, column F reflects the x or no.

Thanks in advance for your help