Weekly Staticitics - formular

  • Thread starter Thread starter Sue Arlett
  • Start date Start date
S

Sue Arlett

My boss wants me to give him weekly statistics of project works coming in and
ones which works which has been completed for each week of the month. is
there a formula for this?
 
Sue,

Say in B1 you have the weeks start date, and in b2 the week end date. The
start Date is in A4:A400 and the finished dates are in B4:b400 then

New Orders for Week:
=SUMPRODUCT(--($A$4:$A$400>=$B$1))-SUMPRODUCT(--($A$4:$A$400>$A$2))

Completed orders for week:
=SUMPRODUCT(--($B$4:$B$200>=$B$1))-SUMPRODUCT(--($B$4:$B$200>$A$2))

This gives you one weeks stats. Replicate for N weeks and adjust the ranges
to suit.

Regards
Peter Atherton
 
My boss wants me to give him weekly statistics of
project works coming in and ones which works which
has been completed for each week of the month. is
there a formula for this?  
Click to expand...

Yes.
 
Back
Top