Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
formulas in excel 2000
Name: alex Date: January 28, 2002 at 07:07:59 Pacific
Comment:
Hello,
I'm using MS office 2000, and in Excel i'm trying to come up with a formula combining 'COUNT' and 'IF' but can't seem to get it right. I would like to be able to select a certain amount of cells, and IF something in those cells matches my criteria, then it should COUNT how many times that occurs in those selected cells. Does that make sense? All i seem to get is "#Value" or "0." Can somebody tell me in which order i should do this. Or atleast give me a few pointers on formulas.
Name: wayne stevens Date: January 28, 2002 at 14:27:10 Pacific
Reply:
in stead of using count and if why not just use "countif" then just highlight the section you want to see if that number is in there and then it will count how many times that number is in that list.
Do this using paste function as it is easy to use.
Hope this helps
0
Response Number 2
Name: alex Date: January 29, 2002 at 04:01:00 Pacific
Reply:
thanks man, i appreciate the help. that's exactly what i needed. i didnt know there was a "countif" formula. wish i had the time to check all of them out.
Summary: How do I clean up (besides sorting and doing it manually) duplicate entries in Excel? For example, I have: A B 1 bill cas 2 bill vm 3 sue vm 4 sue cas 5 sue vm 6...
Summary: Hello: I am a self-taught private developer and have produced an extensive spreadsheet that relies on a variety of VB macros that are accessed through a detailed macro-generated Custom Menu Bar that a...
Summary: Does anyone know if/how you can change default margin settings in Excel 2000 so that anytime I create a new document, it uses my margins (.25 instead on 1")? Thanks. ...
0 
