Posted to microsoft.public.excel.worksheet.functions

Bahareh

external usenet poster

Posts: 19

count & If fomula

Hello

There is a rutine counting each week (very boring) I want to make it
authomatic. I have an spread sheet which 4 columns are important:

city, city status (On/Semi), state, %complete

I want this counting perocess:

1- I want to count: How many cities in each state are in "On" status?
2-I want to count: How many cities in each state are "100%" complete?

Please Help me to get ride of this boring manual updating.
Thanks
BHR

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fomula (if?)	Jules	Excel Worksheet Functions	0	August 8th 06 07:13 PM
Fomula	Steve	Excel Discussion (Misc queries)	2	December 8th 05 07:29 PM
Please help, i need a fomula	Age Formula??	Excel Worksheet Functions	2	October 13th 05 10:32 PM
IF Fomula	DWadding	Excel Discussion (Misc queries)	1	August 3rd 05 05:32 PM
To get fomula to display a Zero	Geo	Excel Discussion (Misc queries)	1	December 30th 04 11:59 PM

All times are GMT +1. The time now is 07:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us