Thanks to people not upgrading to the latest version of excel, i had to search around the net to find a solution to this. luckily i found this site that explained the use of the sumproduct to this situation.
Originally i used the count function and it counted all the 0s in my array! bad boy!
http://fro.instantspot.com/blog/excel
Author Archives: kianhean
Alternative to CountIFs function in excel 2003!
November 11, 2008 – 12:52 pm
Evidence to back up notion of SMU becoming an ultra mugger school
November 6, 2008 – 12:05 am
This is written to catalog sightings and other evidence to support the notion that of SMU becoming an ultra mugger school. This is to prevent people from saying that seniors always think their juniors are more muggerish than themselves without any evidence. It starts…
Pls send me an email, post comments about new evidence, pics, vids [...]
New Macbooks DDR3 giving me a headache
October 15, 2008 – 9:08 pm
Traditionally i would buy a macbook and upgrade its ram to 4gb easily by going down to sim lim square to get apple compatible rams. However, it seems that apple has outdid itself this time and is way beyond what other mainstream notebooks are offering and they do not sell DDR3 rams in sim lim [...]
Get SMU Email through your iPhone
October 13, 2008 – 8:03 pm
Credits to raymond
Email: smustu/yourname.200x@whatever.smu.edu.sg (if you are running firmware 2.1 or above, put domain as SMUSTU and leave it out of the email address)
Server: email.smu.edu.sg
Username: smustu\yourname.200x
Password: ******
Use SSL: On
Hope it helps!
Note: Your iPhone or iPod Touch should be running firmware 2.0 or more
iPhone Settings for SMU
October 1, 2008 – 1:25 pm
Soon i will post an iphone manaual
But till then
How to connect to WLAN-Student
Works only for iphone 3G and 2G (firmware 2.0 onwards i think)
1.Go to settings,Wifi, swtich it on and go to other.
2. Name: WLAN-Student
3. Under security select WPA2 Enterprise (if u dont have this means your firmware is not up to date)
4. Username: [...]
SMU Mac Manual V3.2 Released!
September 12, 2008 – 2:01 am
Go to
http://www.kianhean.com/smu-mac-manual/
Updated in this version!
Version 3.2 (11 Sept 08)
-updated printer settings (no need to find ip and computer name!)
