View Single Post
  #1   Report Post  
tqm1 tqm1 is offline
Junior Member
 
Posts: 11
Default Calculation in Date Range

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--------30
03-06-07---400--------900--------50
04-06-07---400--------400--------20

I want to use following query between
Date range 02-06-07 to 03-06-07

a=sum(weight2)
b=count wight2=0
c=sum(cash)
d=count cash=0
e=total records

Following results are required
a=2300
b=1
c=180
d=1
e=5

Please help