View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMVenhaus JMVenhaus is offline
external usenet poster
 
Posts: 1
Default Converting COUNTIFS to 2003 format

I have the following function in an Excel 2007 workbook and it works well.

=COUNTIFS(Articles!E3:E55,"Quality of
Products",Articles!M3:M55,"0")+COUNTIFS(Articles! F3:F55,"Quality of
Products",Articles!M3:M55,"0")

How would I convert it to a format that would work in the 2003 version?

What I am trying to do is search the E and F columns for one of five topics
and count the number of times that it returns a positive score in the M
column. Separately, I count the negative resoponses so that I can chart the
number of positives and negatives for each of the five topics. If someone
has a better way to do this I would love to hear it.

Thanks