Hi,
You may also use the SUMIF() formula as follows:
=SUMIF(B1:B9,"="&A11,A1:A9)
A11 has either Painting or drawing.
--
Regards,
Ashish Mathur
www.ashishmathur.com
"T. Valko" wrote in message
...
wrote in message
...
On Apr 14, 3:44 am, "T. Valko" wrote:
Assume:
A2:A10 = Week
B2:B10 = Task
D2:D3 = Painting; Drawing
If there are no empty cells within Week, try this arry formula** :
=COUNT(1/FREQUENCY(IF(Task=D2,Week),Week))
If there might be empty cells within Week, use this version** :
=COUNT(1/FREQUENCY(IF((Task=D2)*(Week<""),Week),Week))
Copy down to D3.
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
--
Biff
Microsoft Excel MVP
wrote in message
...
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.- Hide quoted text -
- Show quoted text -
Thanks everyone!
You are lifesavers!
Biff's worked the best!
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP