Question about Microsoft Office Excel 2003 for PC

1 Answer

Countifs How to Convert the COUNTIFS formula in the excel 2007 version to excel 2003 version

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 69 Answers

The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.
=countif(A1:B9,1)

Posted on Jan 21, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Countifs formula


COUNTIF(range,criteria)
Counts the number of cells within a range that meet the given condition.
This COUNTIF formula appears to count only the Employees that have the value "F" in the designated container. ie. Female.

Nov 20, 2013 | Microsoft Excel 2010

1 Answer

MsExcelSheet2007 convert in to MsExcelSheet2003


Hi.
First open your excel files to excel 2007 then save as choose excel 97-2003 workbook.
already read to excel 2003 version.
please see attach photo.


jimmyverdade_33.jpg

Jun 13, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

Formula


check this link it will help you to learn excel

http://people.usd.edu/~bwjames/tut/excel/

dont forget to rate ^^

Jun 08, 2010 | Microsoft Office Professional 2007 Full...

2 Answers

How can i convert documents in wordpad 2003 frm 2007 in windows 2


Open the file in word 2007 and from the office menu take the option CONVERT!

Then the things you want to convert are done..

May 30, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

I need a macro to use in excel 2000 which simulates the countifs function completely


You need to write a for..next loop that loops through the range you would set in the COUNTIF function. In each iteration of that loop, do your comaprisin test. Declare a varialbe to hold the "count" so when the loop ends, you'll have a resulting value.

Apr 27, 2009 | Microsoft Office Excel 2003 for PC

7 Answers

Pptx file converter for office 2007 to office 2003


I am looking for office 2003 2007 converter for using with a word doc

Jul 25, 2008 | Microsoft Office Professional 2007 Full...

4 Answers

How many formulas we can use at a time in Excel


That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

1 Answer

Excel formula


the formulae for the surface area of round disc is
pi * r * r
where pi=3.14 and r =radious of disc= diametre/2 

for this 1st u have 2 calculate the radious of the disc that is
180/2=90mm
then convert it to  m by dividing 1000 ,so radious=90/1000=0.09 m
finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres
for 38 disc multiply 38 with the above area that is
0.025434 * 38=0.966492 sq metres

in excel 2007  u can do it more easily by going 2 formulas tab.
Under formla tab click on engineering formula and  then convert
here u can convert from mm to m
after converting use the above formula i just told u.

Feb 27, 2008 | Business & Productivity Software

2 Answers

2007 version running SLOW!!


Are you trying to open a .xls file instead of an .xlsx file? Xlsx is the excel 2007 file format. Another cause could be a lack of free space on your hard drive. Uninstalling the 2003 version or defragging could do it. One last question: XP or Vista? I find Office 2007 works better with Vista. Good Luck! ---- JG

Jun 21, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

376 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...