Thread: Count Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MO
 
Posts: n/a
Default Count Function

I have 3 colums of data with multiple rows. the first two columns contain
"x"'s while the third contains 1 alphabet. I'm trying to set up a formula
that says if column 3=N, and there is an "x" in column 1 or 2 count "x"
seperatly in each column. (ie. total column would be N, E S,W, then each row
would have a total for "x"'s in that particular row. Same thing, if Column
3=N, if Column 3=S, if Column 3=W. I've been trying for days to get this and
I'm giving up. Can any of you nice folks help?
--
Thank you for you help
MO
Albany, NY