| |||||||
| Register | FAQ | Members List | Calendar | Arcade | Search | Today's Posts | Mark Forums Read |
| Random Nonsense! A general discussion on all earthly and heavenly things. |
 |
| | LinkBack | Thread Tools | Rate Thread |
8th July, 2006, 11:12 AM
| ||||
| ||||
| Quick Excel help needed Going out to all you MS Excel gurus out there.... I need a formula to add up the total number of cells that have a date in them. My spreadsheet has a column with dates that represent when a particular task was completed. I would like to know how many finished tasks there are on the spreadsheet. Any ideas?
__________________ DFI SLi-D, Opteron 144 @ 2.8Ghz, 4x512MB PDP XBLK, 160GB WD Caviar SE, Benq 1620DW DVD-RW, X1800XT 256MB,Custom WC.       |
|
8th July, 2006, 11:35 AM
| ||||
| ||||
| =COUNT(A1:A4) Only works for numbers, I dont see why it wouldnt work for dates. Depending on what format the dates are in. A1:A4 are whatever cells your dates are located between.
__________________   Rig 1: Athlon AM2 6000,4gb,8600GT,320gb SATA2,XP Pro SP3 Rig 2: Toshiba-Centrino Duo 2.16ghz,2gb,7600GT,32gb SSD, XP Pro SP3 Rig 3: Sony Vaio,2ghz,4gb,200gb,X3100,Vista Home Premium Rig 4: Athlon XP 2400+,2gb,2tb,GF4Ti4200,XP MCE Rig 5: Athlon XP 2700+,1gb,2x250gb,Server 08 Rig 6: Pentium 3 866mhz,512mb,40gb,Server 03 |
|
8th July, 2006, 11:44 AM
| ||||
| ||||
| Top man Rondog! Ok, that was too easy!....and I'm dumb! Now can you tell me how to work out how many cells dont have a date in them? ie how many unfinished tasks there are?
__________________ DFI SLi-D, Opteron 144 @ 2.8Ghz, 4x512MB PDP XBLK, 160GB WD Caviar SE, Benq 1620DW DVD-RW, X1800XT 256MB,Custom WC. Last edited by Lazgoat : 8th July, 2006 at 11:45 AM. |
|
8th July, 2006, 12:00 PM
| ||||
| ||||
| =COUNTBLANK(A1:A4) Counts all the empty cells in range of A1 to A4.
__________________ Rig 1: Athlon AM2 6000,4gb,8600GT,320gb SATA2,XP Pro SP3 Rig 2: Toshiba-Centrino Duo 2.16ghz,2gb,7600GT,32gb SSD, XP Pro SP3 Rig 3: Sony Vaio,2ghz,4gb,200gb,X3100,Vista Home Premium Rig 4: Athlon XP 2400+,2gb,2tb,GF4Ti4200,XP MCE Rig 5: Athlon XP 2700+,1gb,2x250gb,Server 08 Rig 6: Pentium 3 866mhz,512mb,40gb,Server 03 |
|
9th July, 2006, 05:36 AM
| ||||
| ||||
| Good man, works a treat! Have a  on me this afternoon! 
__________________ DFI SLi-D, Opteron 144 @ 2.8Ghz, 4x512MB PDP XBLK, 160GB WD Caviar SE, Benq 1620DW DVD-RW, X1800XT 256MB,Custom WC. |
|
9th July, 2006, 06:00 AM
| ||||
| ||||
| Anything else you need to know?
__________________ Intel Core 2 Duo T5500 1.66Ghz 1GB PC2-5300 667Mhz Matsh1ta DVD/RW Drive 232GB Western Digital 'My Book' External HDD USB 2.0 80GB Hitachi SATA HDD Onboard Audio Intel GMA 950 Onboard Video Want to make a difference without leaving your chair?, then join the AOA folding team today!  |
|
9th July, 2006, 06:49 AM
| ||||
| ||||
| Quote:
__________________ Rig 1: Athlon AM2 6000,4gb,8600GT,320gb SATA2,XP Pro SP3 Rig 2: Toshiba-Centrino Duo 2.16ghz,2gb,7600GT,32gb SSD, XP Pro SP3 Rig 3: Sony Vaio,2ghz,4gb,200gb,X3100,Vista Home Premium Rig 4: Athlon XP 2400+,2gb,2tb,GF4Ti4200,XP MCE Rig 5: Athlon XP 2700+,1gb,2x250gb,Server 08 Rig 6: Pentium 3 866mhz,512mb,40gb,Server 03 |
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Rate This Thread | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| quick advise needed | Daston | AMD Motherboards & CPUs | 2 | 6th September, 2006 11:26 AM |
| DFI ULTRA D MOD to SLI - Quick response needed | IceRaptor | AMD Motherboards & CPUs | 5 | 26th March, 2005 06:53 PM |
| Quick recommendation needed! | Lazgoat | Graphics and Sound cards; Speakers and other Peripherals | 7 | 27th April, 2004 11:23 AM |
| VBA and Excel | Rackne | Random Nonsense! | 0 | 10th December, 2001 07:57 PM |
