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

How can I attach an image of my file?

"Don Guillett" wrote:

Look at the help index for SUMIF and then combine

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kmaki" wrote in message
...
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