Counting number of weeks to complete a task
Try this:
=SUM(N(FREQUENCY(IF(Task="Painting",MATCH(Week,Wee k,0)),MATCH(Week,Week,0))0))
=SUM(N(FREQUENCY(IF(Task="Drawing",MATCH(Week,Week ,0)),MATCH(Week,Week,0))0))
Both formulas are required with CRTL+SHIFT+ENTER, not just ENTER
" wrote:
Hi,
Can anyone help me please.
I have a spreadsheet and I am trying to calculate how many weeks a
task took to complete.
The task does not necessairly have to be completed in consecutive
order.
A brief example:
Week Task
1 Painting
1 Painting
1 Drawing
2 Drawing
2 Drawing
2 Drawing
3 Painting
3 Drawing
3 Drawing
From the table the Painting task was completed in 2 weeks and the
Drawing task was completed in 3 weeks.
I would appreciate your help.
|