If two columns match then count one. How? Tried countif and sum .

I

IMC Medrec

I have one column containing clinics. The other column may contain Follow Up
appointments. I'm trying to count the matched sets, i.e. all nuclear
medicine with follow ups, Neurology with Follow Ups, and so on. Here is the
string that is showing the correct number when tested but shows "0" in the
cell. =COUNT(IF((Sheet1!D2:D200="Nuclear Med.")*(Sheet1!G2:G200="Follow
Up"),Sheet1!H2:H200)). The H column has this string: =IF(G19:G217="Follow
Up",1,0) I am trying to count this number if the other two criteria is met.
It doesn't work. Any suggestions?
 
J

Jason Morin

Replace COUNT with SUM and press ctrl + shift + enter to
convert it to an array formula.

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to count rows if 2 columns partially match 5
matching full name to 'two column' name using sumproduct 9
Function to Use when compare sums another column 3
Summing one column based on criteria from two other columns 2
Need to Match Multiple Results and Count Text in Different Column 4
Conditional Count Formula 3
Single formula to find match across four columns? 2
Index Match to add employee number 2

Top