How Do I have excel count 2 cells with conditions (Excel 2003)
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 Ms in one cell (H36) and show all
total of J; Fs (H37) in another separate total cell discounting all
other codes C,E and etc from Column F.
I hope this makes sense. Thank you.
|