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.