I apoligize for my ignorance. Must be old age. Anyway the formula works and I
thank you for your time.

Dave

"Bob Phillips" wrote:

In I36, put M, I37 put F.

In H36, =SUMPRODUCT(--($G$2:$G$200="J"),--($H$2:$H$200=I36))

and copy to H37

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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.