tqm1
06-14-2007, 07:32 PM
Dear Experts
Sheet1 has four columns from (column A : column D) and contains
following data
--date----weiht1----weight2-----cash
01-06-07---500--------200--------50
01-06-07---300---------0--------150
02-06-07---200--------300--------50
02-06-07---100--------600---------0
02-06-07---800---------0---------50
03-06-07---600--------500--------50
03-06-07---400--------900--------50
I want to use following query against date=02-06-07
a=sum(weight2)
b=wight2=0
c=sum(cash)'100
d=cash=0
e=total records
Following results are required
a=900
b=1
c=100
d=1
e=3
Please help
Sheet1 has four columns from (column A : column D) and contains
following data
--date----weiht1----weight2-----cash
01-06-07---500--------200--------50
01-06-07---300---------0--------150
02-06-07---200--------300--------50
02-06-07---100--------600---------0
02-06-07---800---------0---------50
03-06-07---600--------500--------50
03-06-07---400--------900--------50
I want to use following query against date=02-06-07
a=sum(weight2)
b=wight2=0
c=sum(cash)'100
d=cash=0
e=total records
Following results are required
a=900
b=1
c=100
d=1
e=3
Please help