Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Range Calculation | Excel Discussion (Misc queries) | |||
Validate date within range prior to calculation | Excel Discussion (Misc queries) | |||
Calculation based with Range of Date | New Users to Excel | |||
HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions | |||
Date Range and calculation | Excel Worksheet Functions |