Hi all,
I do not know where i went wrong. Any help is greatly appreciated.
I have worksheet D, with many rows (close to 30k) and many columns (around 30 columns).
I need to find rows with conditions (years, selective words in branch, Grade, status, and reviewed)
so effectively.
year branch grade status reviewed
2010 sg A done yes
2011 hk B not done yes
2011 msia A done yes
2010 thai A done yes
2010 sg A done yes
2010 thai A done yes
By right, my search should sum it up and return "4".
I have this code
But no luck. The sum is wrong. Any ideas?
Bookmarks