|
|
 |
| found 17 articles for 0.302 sec |
  |
|
Group: alt.politics.usa.congress · Group Profile · Search for Be100 in alt.politics.usa.congress
Author: CB
Date: Aug 21, 2008 15:28
A tinker for you to try out over there .. My assumptions: Real dates in B2 down, %% in D2 down, desired "Weekly %% production" in E2 down, source data in cols B and D expected within row 2 to 100 (say) In E2: =IF(B2="","",SUMPRODUCT(--(F$2:F$100=weeknum(B2,2)),D$2:D$100)) In F2: =IF(B2="","",weeknum(B2,2)) Select E2:F2, copy down to F100. Col E returns the desired results. P/s:
|
| Show full article (0.74Kb) |
|
 |
|
1 ·
2 ·
next |
|
|