I tried but must be doing something wrong. It would not work. What I would
like to do is to forget the actual working copy and create a very simple
similiar worksheet using just 2 columns and 8 rows. Try a formula for that
and if I can get that to work along with "my" understanding of how it is to
work, then I can go back to the real worksheet and go from there. Make sense?
I apoligize for my ignornance and would appreciate some assistance. I'm using
a worksheet created by another. The way the cells are arranged on it might be
the causing the error.

Thank you in case you are willing to assist.

Dave

"Gilles Desjardins" wrote:

Enter this in H37 and change the letter F for M in H36. I did this with the
conditional sum wizard. Therefore you need a title above each column.
=SUM(IF($F$4:$F$35="J",IF($G$4:$G$35="F",1,0),0)) entered as an array
formula should work.
Use the following keys to create the array formula Ctrl+Shft+Enter

HTH

Gilles


"Dave" wrote in message
...
2 columns (F & G) with several rows. Column "F" includes 7 code letters
(C,E,
J, and etc.) for coding. Column G has only 2 codes. Either "M" or "F". I
want
to show in a total box all the "J" "M"'s in one cell (H36) and show all
total of "J"; "F"'s (H37) in another separate total cell discounting all
other codes C,E and etc from Column "F".

I hope this makes sense. Thank you.