Hello,
I am having trouble converting the following Countifs formula developed in 2007 to work in 2003 Excel.
Basically, I want to count the frequency of "N" in 'Data_Q2 2008'!$S$2:$S$9806, where 'Data_Q2 2008'!$B$2:$B$9806 = 'Metric Upload'!C2.
'Data_Q2 2008'!$B$2:$B$9806 is a list of physicians. 'Metric Upload'!C2 is a pick list for selecting the physican that is in the larger data set using Data Validation.
Thank you!
2007 Countifs Formula:
=COUNTIFS('Data_Q2 2008'!$S$2:$S$9806,"N",'Data_Q2 2008'!$B$2:$B$9806,'Metric Upload'!C2)
Bookmarks