Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countifs equiv in 2003 | Excel Discussion (Misc queries) | |||
translating countifs function to Excel 2003 | Excel Worksheet Functions | |||
COUNTIFS for 2003 | Excel Worksheet Functions | |||
Converting a time format to a String format in Excel | Excel Discussion (Misc queries) | |||
excel's new countifs...on 2003? | Excel Discussion (Misc queries) |