example

col-A COL-B COL-C COL-D COL-E
AA 1 C/S F 05.APR.08
AA 4 S/S S 02.MAY.08
BB 2 C/S S 03.MAY.08
CC 1 C/S F 10.APR.08
AA 0.5 C/S F
DD 2 A/S S
BB 10 C/S F

I WANT THE RESULT IF COL-A=AA, IF COL-E = NON BLANK OR DATE,IF COL-D=S,
COL-B <2, SUM(COL-B)

PLEASE HELP IN THIS
MAX NO OF ROWS MAY BE UPTO 40000 DATAS.

AWAITING YOUR HELP UREGENT PLEASE

S.P.SAMY