How Do I have excel count 2 cells with conditions (Excel 2003)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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)
 
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
 
I apoligize for my ignorance. Must be old age. Anyway the formula works and I
thank you for your time.

Dave
 
Back
Top