how do i sum the amount of time spent on each task in a table?

**Roan242** · 02-28-2012, 10:18 AM

Hello,

i have timings against each task on the data tab and on the summary tab i want to the know the total time spent on each task?

**NBVC** · 02-28-2012, 10:24 AM

Try:

=SUM(IF((Data!$C$2:$W$2=C$3)*(Data!$B$4:$V$15=$B4)*ISNUMBER(Data!$E$4:$Y$15),Data!$E$4:$Y$15))

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down and/or across if you have other headers...

**Roan242** · 02-28-2012, 10:33 AM

Sory what do you mean by confirm CRTL+SHIFT+ENTER?

**NBVC** · 02-28-2012, 10:36 AM

After you enter in the formula, making sure the cell is active (hit F2), you hold the CTRL and SHIFT keys down, then press ENTER.. You should see { } brackets appear around the formula that confirms you entered it in correctly as an array formula.

**Roan242** · 02-28-2012, 10:41 AM

FANTASTIC, thank you very much!

**NBVC** · 02-28-2012, 10:50 AM

You are welcome,

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**NBVC** · 02-28-2012, 10:50 AM

You are welcome,

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save